SELECT a.name
,a.id,b.province FROM
(SELECT NAME,id FROM t_area WHERE parent_id =0) a
LEFT JOIN
(SELECT DISTINCT province FROM t_carbon_area WHERE deleted = 0
UNION
SELECT DISTINCT province FROM t_carbon_prov WHERE deleted = 0 ) b
ON a.id = b.province
,a.id,b.province FROM
(SELECT NAME,id FROM t_area WHERE parent_id =0) a
LEFT JOIN
(SELECT DISTINCT province FROM t_carbon_area WHERE deleted = 0
UNION
SELECT DISTINCT province FROM t_carbon_prov WHERE deleted = 0 ) b
ON a.id = b.province