SELECT *
from USERS u
Join Users_Permission up On U.User_Id = up.user_id
where u.USER_ID = 1
  AND U.Permission_id = 2;