SELECT u.username,r.name,p.name
FROM t_user u
LEFT JOIN user_role ur ON u.id=ur.user_id
LEFT JOIN t_role r ON r.id=ur.role_id
LEFT JOIN role_permission rp ON r.id = rp.role_id
LEFT JOIN t_permission p ON p.id=rp.permission_id
WHERE u.id='u1'
, 相关下载链接:
https://download.csdn.net/download/qq_52369371/87553443?utm_source=bbsseo