SELECT Query取决于另一个

I've two tables that are: list_event and cities

In list_event has a column name 'cities'. I want to take 'cities' value and search in 'cities' table to get city name.

I don't know logic to do that and I haven't code in this moment, .

SELECT * FROM list_event ORDER BY id_event DESC LIMIT 5

Use left join here

SELECT column_name(s) FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;

Probably in your case

SELECT list_event.event, cities.cityName FROM list_event LEFT JOIN cities ON list_event.city_value=cities.city_value;