Someone

SELECT e.id, e.nome, s.nome, c.nome, FROM empresa AS eJOIN segmento AS sON e.segmento = s.idJOIN cidade AS c ON e.cidade = c.id