i think it should maybe possible.
take a look at this and this
you need a relationship field at user or/and at author.
because you should be able to query relationship fields in both directions. you can
show users at author page, and show author details at user page (at least if users and authors are CPTs)
but to get it working you need advanced php/ACF/WP knowledge. if you are unable to adapt the example for your needs, you probably need to hire someone to do it for you.