insert into userPrivilegeTemp        select ui.UserID, rp.PrivilegeID        from UserInfo ui        left join UserRole ur on ur.UserID=ui.UserID        left join RolePrivilege rp on rp.RoleID=ur.RoleID                    and ui.UserID=#{id}            

当mybaties执行到 insert into userPrivilegeTemp这里的时候，进程就卡死了，

后来我改为insert into userPrivilegeTemp(UserID,PrivilegeID)就不会卡了，

应该是mybaties不认识insert into userPrivilegeTemp代表insert into userPrivilegeTemp（UserID,PrivilegeID）

注意：userPrivilegeTemp表就UserID,PrivilegeID2个字段。