Илья М

SELECT t1.`id`, t1.`id_company`, t1.`phone`, t1.`email`, COUNT(t2.`id`)
FROM `company` AS t1
JOIN `company` AS t2 ON t1.`id_company` = t2.`id_company`
GROUP BY t2.`id`;