Sulu\Bundle\ContactBundle\Entity\AccountRepository::findChildrenAndContacts PHP Method

    public function findChildrenAndContacts($id)
    {
        try {
            $qb = $this->createQueryBuilder('account')->leftJoin('account.children', 'children')->leftJoin('account.accountContacts', 'accountContacts')->leftJoin('accountContacts.contact', 'contacts')->select('account')->addSelect('children')->addSelect('accountContacts')->addSelect('contacts')->where('account.id = :accountId');
            $query = $qb->getQuery();
            $query->setParameter('accountId', $id);
            return $query->getSingleResult();
        } catch (NoResultException $ex) {
            return;
        }
    }