如何连接到drupal中的多个数据库以便在表中显示内容

$databases['default']['default'] = array(
  'database' => 'drupal_db',
  'username' => 'drupal_user',
  'password' => 'drupal_password',
  'prefix' => '',
  'host' => 'localhost',
  'port' => '3306',
  'namespace' => 'Drupal\\Core\\Database\\Driver\\mysql',
  'driver' => 'mysql',
);

$databases['second_db']['default'] = array(
  'database' => 'second_db',
  'username' => 'second_user',
  'password' => 'second_password',
  'prefix' => '',
  'host' => 'localhost',
  'port' => '3306',
  'namespace' => 'Drupal\\Core\\Database\\Driver\\mysql',
  'driver' => 'mysql',
);

// 获取第二个数据库连接对象
$database = \Drupal\Core\Database\Database::getConnection('second_db');

// 执行查询
$query = $database->select('table_name', 't');
$query->fields('t', ['column1', 'column2']);
$results = $query->execute()->fetchAll();

// 处理查询结果
foreach ($results as $result) {
  // 处理每行数据
}