Concrete example of WHERE...IN subquery in doctrine 2

EntityRepository.php

<?php
class MyRepository extends EntityRepository
{
    public function whereInSubQuery(User $user)
    {
        $queryBuilder = $this->createQueryBuilder('my_repository');

        $queryBuilder
            ->where(
                $queryBuilder->expr()->in(
                    'my_repository.skill',
                    $this
                        ->createQueryBuilder('subquery_repository')
                        ->select('skill.id')
                        ->from('EntityBundle:Skill', 'skill')
                        ->where('skill.user = :user')
                        ->getDQL()
                )
            )
            ->setParameter(':user', $user);

        return $queryBuilder->getQuery()->getResult();
    }
}

Hello many thank for this gist but there is a issue with

  $this->createQueryBuilder('subquery_repository')

This function in repository return

      $this->_em->createQueryBuilder()
            ->select($alias)
            ->from($this->_entityName, $alias);

You have to replace with

$this->_em->createQueryBuilder()

thnx for this, it helped me