insert into sys_role_menu (role_id,menu_id)
select * from(select * from (select role_id from sys_user_role
where user_id=3) a ,(select menu_id from sys_menu
where menu_type=1) b) c
一个角色:select role_id from sys_user_role
where user_id=3
多个菜单集:select menu_id from sys_menu
where menu_type=1