SELECT c.id,c.depname,c.desc,d.indname,c.status,d.id as indid from enum_dep as c LEFT JOIN (select a.depid,a.indid,b.indname,b.id from enum_dep_ind as a LEFT JOIN enum_ind as b on a.indid = b.id) as d on c.id = d.depid where c.group = 1 order By c.id

结果会出现多个主表1的重复内容

select h.id,string_agg(h.indname, ',') as names ,string_agg(h.indid::TEXT,',') as indid from (SELECT c.id,c.depname,c.desc,d.indname,c.status,d.id as indid from enum_dep as c LEFT JOIN (select a.depid,a.indid,b.indname,b.id from enum_dep_ind as a LEFT JOIN enum_ind as b on a.indid = b.id) as d on c.id = d.depid where c.group = 1 order By c.id) as h GROUP BY h.id

string_agg('字符串'，‘，’)  或者array_agg（‘字符串’）

SELECT j.id,j.status,j.group,j.groupname,w.names,w.indid,j.depname,j.desc from enum_dep as j LEFT JOIN (select h.id,string_agg(h.indname, ',') as names ,string_agg(h.indid::TEXT,',') as indid from (SELECT c.id,c.depname,c.desc,d.indname,c.status,d.id as indid from enum_dep as c LEFT JOIN (select a.depid,a.indid,b.indname,b.id from enum_dep_ind as a LEFT JOIN enum_ind as b on a.indid = b.id) as d on c.id = d.depid where c.group = 1 order By c.id) as h GROUP BY h.id) as w on w.id =j.id where j.group =1

SELECT d.id,d.pid,d.name,d.unit,d.desc,d.status,string_agg(c.indname, ',') as names,string_agg(c.id::TEXT,',') as indid 

from enum_indicator as d LEFT JOIN 

(select a.indicatorid,b.indname,b.id from enum_indu_indi as a LEFT JOIN enum_ind as b on a.industryid = b.id) as c on d.id = c.indicatorid GROUP BY d.id

、、另外一种方法

select a.id,a.username,array_to_string(array(SELECT (SELECT d.rolesname FROM roles_infor as d WHERE d.id=b.rid) FROM user_roles as b WHERE b.uid=a.id),',') as userrole from user_infor as a group by a.id