/** * @return \Doctrine\ORM\QueryBuilder */ public function getAccounts() { return $this->accountRepository->createQueryBuilder('a')->leftJoin('a.account', 'c')->leftJoin('c.person', 'p')->leftJoin('p.users', 'u')->andWhere('u.id = :id')->setParameter('id', $this->user->identity->id)->getQuery()->getResult(); }