Zend Framework:如何连接两列仍然使用fetchPairs()？

// 引入Zend库
use Zend\Db\Sql\Select;
use Zend\Db\Sql\Sql;
use Zend\Db\Adapter\Adapter;

// 创建数据库适配器
$adapter = new Adapter([
    'driver' => 'Pdo_Mysql',
    'database' => 'your_database',
    'username' => 'your_username',
    'password' => 'your_password',
    'hostname' => 'your_hostname',
]);

// 创建SQL查询对象
$sql = new Sql($adapter);

// 创建查询
$select = new Select();
$select->from(['t1' => 'table1'])
       ->join(['t2' => 'table2'], 't1.column1 = t2.column2')
       ->columns(['column1', 'column2']);

// 获取查询结果
$statement = $sql->prepareStatementForSqlObject($select);
$result = $statement->execute();
$pairs = $result->fetchPairs();

// 输出结果
foreach ($pairs as $key => $value) {
    echo "Key: $key, Value: $value\n";
}