如何使用连接表更改Doctrine结果中的数组结果层次结构

// Step 1: 创建连接表实体
// ConnectionEntity.php
use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity
 * @ORM\Table(name="connection_table")
 */
class ConnectionEntity
{
    /**
     * @ORM\Id
     * @ORM\ManyToOne(targetEntity="Entity1")
     * @ORM\JoinColumn(name="entity1_id", referencedColumnName="id")
     */
    private $entity1;

    /**
     * @ORM\Id
     * @ORM\ManyToOne(targetEntity="Entity2")
     * @ORM\JoinColumn(name="entity2_id", referencedColumnName="id")
     */
    private $entity2;

    // Getters and setters
}

// Step 2: 更新实体关系
// Entity1.php
use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity
 * @ORM\Table(name="entity1")
 */
class Entity1
{
    // Entity1的属性和方法

    /**
     * @ORM\OneToMany(targetEntity="ConnectionEntity", mappedBy="entity1")
     */
    private $connections;

    // Getters and setters
}

// Entity2.php
use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity
 * @ORM\Table(name="entity2")
 */
class Entity2
{
    // Entity2的属性和方法

    /**
     * @ORM\OneToMany(targetEntity="ConnectionEntity", mappedBy="entity2")
     */
    private $connections;

    // Getters and setters
}

// Step 3: 查询结果
// 使用DQL查询结果
$query = $entityManager->createQuery('SELECT e1, e2 FROM Entity1 e1 JOIN e1.connections c JOIN c.entity2 e2');
$results = $query->getResult();

// Step 4: 调整结果层次结构
$adjustedResults = [];
foreach ($results as $result) {
    $entity1 = $result[0];
    $entity2 = $result[1];

    $entity1Id = $entity1->getId();
    $entity2Id = $entity2->getId();

    if (!isset($adjustedResults[$entity1Id])) {
        $adjustedResults[$entity1Id] = [
            'entity1' => $entity1,
            'entity2' => [],
        ];
    }

    $adjustedResults[$entity1Id]['entity2'][$entity2Id] = $entity2;
}

// Step 5: 返回结果
return $adjustedResults;