How to perform a join query using Symfony and Doctrine Query Builder
Note that you should write this query in your MyEntityRepository
public function getMyEntityWithRelatedEntity($parameter) { $query = $this->createQueryBuilder('e') ->addSelect('r') // to make Doctrine actually use the join ->leftJoin('e.relatedEntity', 'r') ->where('r.foo = :parameter') ->setParameter('parameter', $parameter) ->getQuery(); return $query->getResult();}
And then use it in your controller/service :
$manager = $this->getDoctrine()->getManager();$results = $manager->getRepository(MyEntity::class)->getMyEntityWithRelatedEntity(1);