SELECT dept.name, COUNT(emp.id) AS cnt
FROM dept
LEFT JOIN emp
ON dept.id = emp.id_dept
WHERE emp.salary > 1000
GROUP BY emp.id_dept
$like = [];
foreach ($array as $value) {
$like[] = "record LIKE '%$value%'";
}
$sql = 'SELECT * FROM tbl WHERE ' . implode(' OR ', $like);