SELECT `a`.`name`, `a`.`roc_no`, `a`.`website`, count(b.id) as count_documents
FROM `customer` `a`
LEFT JOIN `kbs__document` `b` ON `b`.`company_id` = `a`.`id`
WHERE `a`.`is_delete` =0
AND `a`.`id` = '2'
GROUP BY `a`.`id`
ORDER BY `a`.`name` ASC