我尝试在symfony中生成子查询以进行填充和表单选择，但收到以下错误消息
[Semantical Error] line 0, col 167 near 'd2 WHERE d2.distributor': Error: 'd2' is already defined.
这是我的密码

-`>add('doctor', EntityType::class, [
                'class' => Doctor::class,
                'query_builder' => function (EntityRepository $er) use ($options) {

                $subquery =  $er->createQueryBuilder('d2')
                    ->select('')
                    ->from('AppBundle\Entity\Distributor', 'd2')
                    ->andWhere('d2.distributor = :distributor_subquery')
                    ->setParameter('distributor_subquery', $options['user']);

                $query =  $er->createQueryBuilder('d');
                $query->select('d')
                    ->where('d.distributor = :distributor')
                    ->setParameter('distributor', $options['user'])
                    ->orWhere($query->expr()->in('d.distributor', $subquery->getDQL()))
                    ->orderBy('d.name', 'ASC')
                    ->addOrderBy('d.surname', 'ASC');

                return $query;
            },`

d2别名定义了两次$er->createQueryBuilder('d2')
以及
->from('AppBundle\Entity\Distributor', 'd2')
但在这两个函数中，该参数都是必需的
我试过
$subquery = $er->createQueryBuilder() ->select('') ->from('AppBundle\Entity\Distributor', 'd2') ->andWhere('d2.distributor = :distributor_subquery')
但它不起作用