How to display table values ​​by relation in MYSQL?

Question

MySQL

There are 3 tables
The first users_city stores id_user and id_city .
In another cities : city_id , city_name
In the third users : id_user , name
How to get data from Vasya Samara or Oleg Moscow at the output?
How to form a request correctly?

Answer 1

JOIN