mysql一对多，将多条数据合并成一条数据，指定字段数据拼接展示

yzhSWJ

3014人浏览 · 2023-02-10 15:17:56

yzhSWJ · 2023-02-10 15:17:56 发布

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