select au.id ,au.name ,au.account ,ul.path_name
from ayj_admin_user as au
left join mall_ser_router_user_relation as ul
on ul.admin_user_id = au.id
where au.type = 3 and
ul.router_id in (1,2,3)
limit 0,10合并后
select au.id ,au.name ,au.account ,GROUP_CONCAT(ul.path_name) AS routerNames
from ayj_admin_user as au
left join mall_ser_router_user_relation as ul
on ul.admin_user_id = au.id
where au.type = 3 and
ul.router_id in (1,2,3)
GROUP BY au.id
limit 0,10
版权声明：本文为yuzheh521原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。