功能:查询出来的列可能是多条记录,这时候会报错[Err] 1242 - Subquery returns more than 1 row,所以需要把数据合并为一条记录,就用到该函数。
select m.*,(select p.res_name from sys_resource p where p.res_id = m.parent_id) as parentName,
(select group_concat(r.role_name) as role_name_list from sys_role_resource p , sys_role_zs r where p.res_id = m.res_id and p.role_id = r.role_id GROUP BY m.res_id) as roleNameList
from sys_resource m