Select not repeated results from same tables in different databases
SELECT ... FROM db1.user
UNION DISTINCT
SELECT ... FROM db2.user
UNION DISTINCT
SELECT ... FROM db3.user
;


The DISTINCT will de-dup based on what you have in the select: ...