I once signed up on my brother's ps4 but would now like to sign up on my own, which I got fresh. If my brother now deletes the account from his ps4, is he still there on my ps4? Or is it completely deleted?
No…
Your Acc is still there, just register and then it will work.
You can then log in to another ps4 with the account