将SQL查询的循环合并为一个SQL查询

我在PHP中构建了一个循环，生成500个SQL查询，但我想将500个SQL询问合并为一个，并获得相同的回报（公司和每个公司的用户数）

PHP代码示例

$companies =  array();
foreach ($fortune500Service->listAll() as $c ){
  $count = $entityManager
  ->createQueryBuilder()
  ->select("count(u)")
  ->from("AppBundle'Entity'User","u")
  ->where("u.email LIKE :d")
  ->setParameter("d", "%@" . $c["Domain"])
  ->getQuery()->getSingleScalarResult();
  if ($count == 0) {
    continue;
  }
  $companies[] = array(
      "Domain" => $c["Domain"],
      "Company" => "{$c["Company"]} ({$count})",
  );
}
return $companies;

我想要合并的2个SQL查询的示例

查询1

SELECT 
  count(u0_.id) 
FROM 
  user u0_ 
WHERE 
  u0_.email LIKE '%@company1.com' 

查询2

SELECT 
  count(u0_.id)
FROM 
  user u0_ 
WHERE 
  u0_.email LIKE '%@company2.com' 

我更喜欢使用createQueryBuilder的解决方案http://symfony.com/doc/current/book/doctrine.html#querying-for-objects-using-doctrine-s-query-builder，但我也很喜欢SQL本机查询。