使用group_concat()和group by显示相同名字的人的id号：

使用group_concat()和group by显示相同名字的人的id号：

select d.id,d.pid,d.code,d.name,group_CONCAT(acode,’:’,aname) res from pub_dict d
join(
select aid,apid,acode,aname,anum from (
select a.id as aid,a.pid as apid,a.code as acode,a.name as aname,a.num as anum from pub_dict a
JOIN pub_dict b on a.pid=b.id
) c
) e
on e.apid=d.id
group by d.id,d.pid,d.code,d.name
having d.pid=‘0’