select a.*,group_concat(b.id separator ',') as name from doctor as a left join calendar as b on a.id=b.doctor_id group by a.id;