$sql = $db->query("SELECT c.name, c.id, c.about, c.subcategory, COUNT(p.cat_id) AS cnt FROM firm AS c 

    LEFT JOIN glass AS p ON p.cat_id = c.id GROUP BY c.id");