1、查询 select distinct a.menu_id from sys_role_menu as a,sys_user_role as b where a.role_id=b.role_id and b.user_id='1' order by a.menu_id
2、查询select distinct menu_id from sys_role_menu where role_id in (select role_id from sys_user_role where USER_ID='1') order by menu_id
两个表完成功能一样，谁快，经过测试，是连接块