public function getCountBy($field, $value) { $qb = $this->createQueryBuilder("u"); $qb->select("count(u.id)")->where($qb->expr()->eq("u.{$field}", ':value'))->setParameter("value", $value); return $qb->getQuery()->getSingleScalarResult(); }