Could you explain what your particular goals are here for this multiple-ID configuration?
Unfortunately, a common outcome of multiple Apple IDs can be a mess.
Apps and subscriptions and most media can’t be moved, which means updates will require the respective IDs.
You can create and use a second ID for, for instance, a completely separate email address. That works.
But unless you’re scrupulous around isolating purchases to one or to whatever associated group (ID) that purchase applies, or don’t purchase at all, problems and confusion tends to ensue.