create procedure setUserRole(userId int, startnum int,endNum int)

begin

declare i int;

set i = startnum;

while i< endNum do

INSERT into sys_user_role(user_id,role_id,create_time) VALUES (userId, i, NOW());

        set i=i+1;

end while;

end;

call  setUserRole(2,16,23);