select User.* from User join in Status on User.s_id = Status.id where Status.mark = 'SuperAdmin'
select name form User where s_id in(select s_id from Status where mark = 'SuperAdmin')
HQL:
select u from User u, Status s where u.s_id = s.id and s.mark = 'SuperAdmin'