删掉不需要的roleid scm

SELECT * FROM sys_menu where parent_id=‘2‘ and (id=13 or id=2)

SELECT * from sys_role_menu where role_id=1 
and menu_id not in(
13,2,14,17,20,30,4,3,56,67,7
)

delete from sys_role_menu where role_id=1 
and menu_id not in(
13,2,14,17,20,30,4,3,56,67,7
)

-- delete from sys_role_menu where role_id=‘afb46d9c530042788c6ab8e4a60b4b65‘