SELECT
a.*,
GROUP_CONCAT( b.`name` ) username
FROM
sacw_auth_ac a
inner JOIN (
select u.*,na.`name` from sys_user u,t_real_name_authentication na
where u.account_id = na.id_number
) b
ON FIND_IN_SET( b.face_id, a.auth_user )
GROUP BY
a.id
MySQL以逗号分隔查出关联表
最新推荐文章于 2024-04-27 13:27:01 发布