SELECT 30 AS city1_id, A.city_id AS city2_id, B.distance, B.duration, A.city_latitude, A.city_longitude FROM tbl_city A 
LEFT JOIN tbl_distance B ON (A.city_id = B.city1_id AND B.city2_id = 30) OR (A.city_id = B.city2_id AND B.city1_id = 30) 
WHERE parent_id = 30 AND city_id != 431 ORDER BY A.city_name