Miscellany

t_user
 id | name | locationid
 1  | paul |     1
 2  | oli  |     2

t_location
 id  |  location_name
  1  |     england
  2  |     wales

output

id | name | location
 1 | paul | england
 2 | oli  | wales