SELECT c.*, count(p.*)
FROM prod_faq AS p, cat_faq AS c
WHERE c.id_cat_faq = p.id_prod_faq
GROUP BY p.id_prod_faq

credo sia questa la soluzione, provala