public function getUsersForRiaAdmin(User $riaAdmin) { $riaGroupNames = $riaAdmin->getGroupIds(); $qb = $this->createQueryBuilder('u'); $qb->leftJoin('u.groups', 'g')->leftJoin('u.profile', 'up')->where($qb->expr()->in('g.id', $riaGroupNames))->andWhere('up.ria_user_id = :owner_id AND (u.roles LIKE :role_ria_admin OR u.roles LIKE :role_ria_user)')->orWhere('u.id = :owner_id')->setParameters(array('owner_id' => $riaAdmin->getRia()->getId(), 'role_ria_admin' => '%"ROLE_RIA_ADMIN"%', 'role_ria_user' => '%"ROLE_RIA_USER"%')); //echo '<pre>'; //echo($qb->getQuery()->getSQL());die; return $qb->getQuery()->getResult(); }