Multiple systems share one user table

there are system An and system B.
system An owns database An independently, and system B owns database B.

system An and system B share a set of user information database, database C.
Database C stores all the information about the user, such as name, birthday, gender, etc.

question:
when system A wants to jointly check user information (for example, system A queries the details of all users under an organization), these functions can only be achieved through cross-database joint search (database An and database C).
this will make the code look ugly. Is there a more reasonable way to query or design the system architecture?

original question:
idea of sharing user information among multiple subsystems of https://codeshelper.com/q/1010000015878010">?


make the C system rpc, to store user details and provide add, delete, query and modify interfaces. An appid B user table plus a unique user table. When registering, A Magi B only saves the account password status, and Synchronize through the rpc interface other details including appid to the C system. When obtaining information, take appid to C system to inquire according to A _ mai B system

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b34c44-342ed.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b34c44-342ed.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?