/** * Find users that have the specified role * * @param Role $role * * @return ArrayCollection|QueryBuilder */ public function findByRole($role) { $queryBuilder = $this->createQueryBuilder('u')->select('u')->innerJoin('u.roles', 'r')->where('r.id = :role_id')->setParameter('role_id', $role->getId())->orderBy('u.lastname', 'ASC'); return $this->processQuery($queryBuilder); }