如何在symfony规则中写入子查询

use Doctrine\ORM\EntityRepository;

class YourEntityRepository extends EntityRepository
{
    public function createSubquery()
    {
        $qb = $this->createQueryBuilder('e');
        
        // 构建子查询逻辑
        $subquery = $qb->select('s.id')
            ->from('YourBundle:SubEntity', 's')
            ->where('s.someField = :value')
            ->setParameter('value', 'some value')
            ->getDQL();
        
        // 返回子查询
        return $qb->expr()->in('e.id', $subquery);
    }
}

use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use App\Repository\YourEntityRepository;

class YourController extends AbstractController
{
    public function someAction(YourEntityRepository $repository)
    {
        // 获取子查询
        $subquery = $repository->createSubquery();
        
        // 使用子查询构建主查询
        $qb = $repository->createQueryBuilder('e')
            ->where($subquery);
        
        // 执行查询
        $result = $qb->getQuery()->getResult();
        
        // 处理结果
        // ...
    }
}