from user_table where userid not in(select user_role_id from role where roleid=1)

------解决方案--------------------
select o from User o inner join o.roles r where r <> :role
这样的？