doctrine-query-to-object.php

$qb = $this->createQueryBuilder('p');

        $qb
        ->select('partial p.{id, name}, partial pmmp.{id}')
        ->leftJoin('p.contractsRenovation', 'pmmp')
            ->where('p.id = :productId')
            ->setParameter('productId', $productId);

        return $qb->getQuery()->getResult(Query::HYDRATE_ARRAY);

$qb = $this->createQueryBuilder('p');

        $qb
        ->select('p', 'pmmp')
        ->leftJoin('p.contractsRenovation', 'pmmp')
            ->where('p.id = :productId')
            ->setParameter('productId', $productId);

        return $qb->getQuery()->getResult(Query::HYDRATE_OBJECT);