是否可以在Doctrine中组合fetch joins和COUNT？

$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder->select('e')
    ->from('Entity', 'e')
    ->join('e.relatedEntity', 'r')
    ->where('e.someCondition = :condition')
    ->setParameter('condition', $condition);

// 使用fetch joins获取关联实体的数据
$queryBuilder->leftJoin('e.anotherRelatedEntity', 'a')
    ->addSelect('a');

// 使用COUNT函数计算满足特定条件的记录数量
$countQueryBuilder = clone $queryBuilder;
$countQueryBuilder->select('COUNT(e.id)');

// 执行查询并获取结果
$query = $queryBuilder->getQuery();
$result = $query->getResult();

// 执行COUNT查询并获取结果
$countQuery = $countQueryBuilder->getQuery();
$count = $countQuery->getSingleScalarResult();