select k.nama_kota as kota, coalesce(j.jml, 0) as jml
from tbl_kota k
left join (
SELECT b.id_kota as kota,count(a.id_sinc) jml FROM `tbl_syncronasi` a
left join tbl_toko c on a.id_toko = c.kode_toko
left join tbl_kota b on c.kode_kota = b.id_kota
where id_status=1
group by b.nama_kota order by b.nama_kota
) j on
j.kota = k.id_kota