Te has equivocado en el code no es cities.id sino cities.state_id
Código:
SELECT countries.name, states.state, cities.city
FROM countries LEFT OUTER JOIN states
ON countries.country_id=states.country_id LEFT OUTER JOIN cities ON states.state_id=cities.state_id