insert into 通过Select来实现

INSERT INTO bs_sys_role_permission (role_id, permission_id, state, remark, version, create_time ) SELECT 33 as role_id,permission_id,state,remark,version,NOW()
FROM
	bs_sys_role_permission 
WHERE
	role_id = 31;