Yes you can indeed have 2 Cash APP accounts in your name even when you just need 2 separate individual cash app accounts.
I have 2 Cash APP accounts myself and use one just to keep money in so I can use it to pay bills and I move money from one cash app account to the other one just for paying bills.
Then I have my other Cash APP account for normal spending of things I just want to buy or for paying for Groceries, gasoline etc.
However you can only have one bank account linked to each cash app account so you'll need separate bank accounts to link to the two different cash app accounts.
You can also have one cash app account for personal and one for business or multiple cash app accounts for different business if you own more than one business.
Or you can have a few cash app accounts for personal use as well.