gistfile1.txt

<?php

class FooRepository extends EntityRepository
{
    public function findCategories()
    {
        return $this->getCategoriesQueryBuilder()
            ->getQuery()
            ->getResult();
    }

    public function findCategoriesWithMedia()
    {
        return $this->getCategoriesQueryBuilder()
            ->addSelect('m')
            ->leftJoin('p.medias', 'm')
            ->getQuery()
            ->getResult();
    }

    private function getCategoriesQueryBuilder()
    {
        return $this->getEntityManager()->createQueryBuilder()
            ->select(['c', 'p', 'm'])
            ->from('AppBundle:FeatureProduct', 'c')
            ->join('c.product', 'p')
            ->join('p.category', 'a')
            ->orderBy('c.id', 'DESC');
    }
}