搞错了 是等于0 啊~~~

SELECT DISTINCT

su.user_id,

sur.role_id,

sr.role_name,

su.user_source 

FROM

`fgbp-sca`.`sys_user` su

JOIN `fgbp-sca`.sys_user_role sur ON sur.user_id = su.user_id

JOIN `fgbp-sca`.sys_role sr ON sr.role_id = sur.role_id 

AND sur.role_id IS NOT NULL WHERE su.user_source<>0

UNION ALL

SELECT XXXXXXXXX

FROM XXXXX

再JOIN 另外一个表

WHERE su.user_source=0