How to cancel auto-renew in appstore and stop the app from trying to charge money?

I mistakenly pressed purchase a subcription in Capcut and I don't have enough fund for the app to draw out the money. I contacted Capcut and the support told me to close the auto-renew to resolve the problem. However, in Appstore it doesn't show in Subscription but it shows in Purchase History with the warning of billing problem and pending for Capcut subscription. How can I delete it?