Php 如何将子查询结果添加到学说 2 中主查询的末尾

The quickest way is to merge the results of both queries.
As an old user of symfony / doctrine :
First thing i would say. Do not make a function that does two different things as much as you can.
Second, i advise you to not use select() function if it does not impact performance to remove it. It will help you have a better sustainable code. I mean it is optional to use it.

如果我完全理解您的用法，那么第二个请求的结果必须位于主请求的末尾是必须的. 您可以执行UNION，但它将生成一个不能在其他用例中重复使用的查询.这得靠你自己了.

以下是我对您可以做的事情的简单看法

public function findNewestPosts(): array
{
        $qb = $this->createQueryBuilder('article');
        $qb->where('article.visible = 1')
            ->addSelect('image')
            ->andWhere('article.published_at <= :present_date')
            ->setParameter('present_date', date('Y-m-d H:i:s'))
            ->leftJoin('article.img', 'image')
            ->orderBy('article.id', 'DESC')
            ->setMaxResults(30);

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

public function findPostByIds(array $ids): array
{
        $qb = $this->createQueryBuilder('article');
        $qb->where('article.id IN ('.implode(',', $ids).')')
            ->andWhere('article.visible = 1')
            ->orderBy('article.id', 'DESC')
        return $qb->getQuery()->getResult();
}

请看:

->addSelect('image')

它会自动将图像添加到主select *，这是通过删除select()功能来完成的. 它将在调用$article->getImage();时阻止自动子查询(例如，如果您仅在twig中调用它，则相同) 对于这种情况，这是一个很好的性能优化，否则它将 for each 项目执行1个子查询.

然后在您的服务/控制器/其他内部:

$newestPosts = $yourRepository->findNewestPost();
$fixedPosts = $yourRepository->findPostByIds([1,2,3,4]);
$posts = array_merge($newestPosts, $fixedPosted);