What you could do is send the BTC in the unconfirmed TX to your other BTC addresses. More instructions here https://bitcoinelectrum.com/how-to-do-a-manual-child-pays-for-parent-transaction/
How about if I have transaction made and I sent all bitcoins from my wallet to another wallet now I don't have remaining balance. So, how can I do the CPFP manually without balance remaining?
Technically, just as all cryptocurrency transactions, you have to have balance to pay the confirming miners. This will come from the address from which you will sign the transaction.
For example, I need the private key of address 1ExampleOnLy to sign>send/broadcast a TX. 1ExampleOnLy is probably the recipient of the unconfirmed TX and from where you will pay the miners.
If 1ExampleOnLy doesn't have any BTC, you can't pay the miners and you can't send BTC or do a CPFP TX.