Inner Join

/*
  Inner Join
*/

SELECT
  u.user_id,
  u.user_name,
  l.lang_name
FROM
  `users` u
INNER JOIN
  `langs` l
ON
  u.lang_id = l.lang_id;