批量插入关联表sql

-- role_id固定为1，插入所有permission_id(给固定角色赋予所有权限)
INSERT INTO `sys_role_permission` ( `role_id`, `permission_id` ) (SELECT (1) `role_id`, id AS `permission_id` FROM sys_permissions );

-- 给查询到的角色赋予所有权限
INSERT INTO `sys_role_permission` ( `role_id`, `permission_id` ) ( SELECT ( SELECT id FROM sys_roles WHERE role_code = 'oncall' ) `role_id`, id AS `permission_id` FROM sys_permissions );