SELECT 
  DT.name as district, 
  CT.name as city 
FROM 
  cscart_companies C 
  LEFT JOIN cscart_cities CT ON C.city_id = CT.city_id 
  LEFT JOIN cscart_districts DT ON C.district_id = DT.district_id 
WHERE 
  company_id = 792