[sql]SELECT c.name,c.id, count(p_id)
FROM cat c
LEFT JOIN program_cat pc ON pc.cat_id =c.id
LEFT JOIN program p ON pc.p_id =p.id
GROUP BY cat_id[/sql]