SELECT DISTINCT
m.perms
FROM
sys_menu m
LEFT JOIN sys_role_menu rm ON m.menu_id = rm.menu_id
LEFT JOIN sys_user_role ur ON rm.role_id = ur.role_id
LEFT JOIN sys_role r ON r.role_id = ur.role_id
WHERE
m.STATUS = '0'
AND r.STATUS = '0'
AND ur.user_id = '44';
12-11
981
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
09-04
2万+
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
06-04
2274
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)