How do I transfer money from my apple account to my Apple Pay or apple cash

You can use Apple ID funds only to make purchases from the App Store, iTunes Store, or Apple Books, or buy iCloud storage.

I would like to know if I could get a cash advance on my Apple Card and send it to my Apple Cash account, is that possible??

Not if you don't remember the answers to your security questions. Then you're stuck in a loop.