请问如何实现如下需求？

[成都-狗蛋儿]

最终显示的结果

TELNET，SSH，FTP 1
FTP服务，SSH，ORACLE服务 4
……依次类推

[成都-狗蛋儿]

自己搞定了，求大神给予评价！！！

SELECT * FROM (SELECT t3.id,t3.resourceid,t3.name,array_to_string(ARRAY(SELECT t1.name FROM t_resource_service AS t1 LEFT JOIN t_resource_account_service AS t2 ON t1.id = t2.serviceid WHERE t1.status=1 AND t2.accountid  =t3.id ),',') AS servicename FROM t_resource_account AS t3 WHERE t3.status=1) AS t6 LEFT JOIN (SELECT t4.name AS resourcename,t4.id,t5.name AS groupname FROM t_resource AS t4 LEFT JOIN t_resource_group AS t5 ON t4.groupid = t5.id WHERE t4.status = 1) AS t7 ON t6.resourceid = t7.id WHERE t6.resourceid = 26

[成都-狗蛋儿]

SELECT * FROM (SELECT t3.id,t3.resourceid,t3.name,array_to_string(ARRAY(SELECT t1.name FROM t_resource_service AS t1 LEFT JOIN t_resource_account_service AS t2 ON t1.id = t2.serviceid WHERE t1.status=1 AND t2.accountid  =t3.id ),',') AS servicename FROM t_resource_account AS t3 WHERE t3.status=1) AS t6 LEFT JOIN (SELECT t4.name AS resourcename,t4.id,t5.name AS groupname FROM t_resource AS t4 LEFT JOIN t_resource_group AS t5 ON t4.groupid = t5.id WHERE t4.status = 1) AS t7 ON t6.resourceid = t7.id WHERE t6.resourceid = 26

[iibetter]

自己解决最好.