อยากให้แสดงข้อมูลทั้งหมด เนื่่องจากว่า GROUP BY แล้วมันขึ้นเฉพาะกลุ่มตามคำสั่งเงื่อนไข แต่อีกข้อมูลอื่นๆที่ไม่ตามคำสั่งไม่ขึ้นครับ

$sql            = " SELECT  id,
              sm_pla_seed_varieties,
              varieties_id,
              center_name,
              sm_pla_seed_sources,
              DATE_FORMAT(last_update, '%Y/%m/%d %H:%i:%s') as last_update,
              (SELECT GROUP_CONCAT(DATE_FORMAT(date_date,'%d/%m/%Y') ORDER BY date_date) FROM db_data_subdate WHERE data_id = db_data.id AND date_type = 1 GROUP by data_id) as date_sapling,
              (SELECT GROUP_CONCAT(DATE_FORMAT(date_date,'%d/%m/%Y') ORDER BY date_date) FROM db_data_subdate WHERE data_id = db_data.id AND date_type = 2 GROUP by data_id) as date_plant,
              s_pla_plant_area,
              sm_pla_plant_note
                                              FROM db_data
                                  WHERE  sm_cor_year ='".$sm_cor_year."'
                                   AND sm_cor_season ='".$sm_cor_season."'
                                             AND type='1'

SELECT id,
sm_pla_seed_varieties,
varieties_id,
center_name,
sm_pla_seed_sources,
DATE_FORMAT(last_update, '%Y/%m/%d %H:%i:%s') as last_update,
s1.gc as date_sapling,
s2.gc as date_plant,
s_pla_plant_area,
sm_pla_plant_note
FROM db_data d
left join (
	SELECT data_id, GROUP_CONCAT(DATE_FORMAT(date_date,'%d/%m/%Y') ORDER BY date_date) gc
	FROM db_data_subdate 
	WHERE date_type = 1 
	GROUP by data_id
) s1 on s1.data_id=d.id
left join (
	SELECT data_id, data_type, GROUP_CONCAT(DATE_FORMAT(date_date,'%d/%m/%Y') ORDER BY date_date) gc
	FROM db_data_subdate 
	WHERE date_type = 2 
	GROUP by data_id
) s2 on s2.data_id=d.id

WHERE sm_cor_year = 2560
AND sm_cor_season = 1
AND type='1'

select c.* , d.* 
from table_center c
left join (
   ## sql statement ของ จขกท นำมาใส่ตรงนี้
) as s on c.name = s.center_name