select k.kitap_adi,count(y.yayinevi_id) as sayi from kitap as k
left join yayinevi as y on y.yayinevi_id = k.yayinevi_id
group by k.kitap_id


Bu şekilde kullanabilirsin