New to mySQL Relationships
SELECT  u.user_id, 
        u.user_name, 
        u.pass_word,
        p.permission_name,
        p.permission_type
FROM Users u
  INNER JOIN Permissions p
ON u.permission_id  = p.p_id;


Max.