doctrine-dto-example.php

public function findDataByProductId(int $productId)
    {
        $qb = $this->createQueryBuilder('p');

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

    return \array_map(
        function (array $result) {
            return new ProductDto($result['name'], $result['contractsRenovation']);
        },
        $qb->getQuery()->getResult(Query::HYDRATE_ARRAY)
    );
    }