需求:在做权限管理是需要表格显示一个用户的多个角色或者要显示一个角色的多个权限时,可以用SQL读数据进行填充
SELECT
su.*, e.employee_name,
GROUP_CONCAT(sr.id
) role_id,
GROUP_CONCAT(sr.`name` separator '/') role_name
FROM
system_user su
JOIN employee e ON su.employee_id = e.employee_id
JOIN system_user_role sur ON su.id
= sur.user_id
JOIN system_role sr ON sr.id
= sur.role_id
GROUP BY su.id
su.*, e.employee_name,
GROUP_CONCAT(sr.id
) role_id,
GROUP_CONCAT(sr.`name` separator '/') role_name
FROM
system_user su
JOIN employee e ON su.employee_id = e.employee_id
JOIN system_user_role sur ON su.id
= sur.user_id
JOIN system_role sr ON sr.id
= sur.role_id
GROUP BY su.id