如何在symfony中连接到已配置数据库以外的其他数据库

doctrine:
    dbal:
        default_connection: default
        connections:
            default:
                # 默认数据库连接配置
                # ...
            second_database:
                driver: pdo_mysql
                host: second_database_host
                port: second_database_port
                dbname: second_database_name
                user: second_database_user
                password: second_database_password

services:
    Doctrine\DBAL\Connection:
        factory: ['Doctrine\DBAL\DriverManager', 'getConnection']
        arguments:
            - { url: '%env(resolve:DATABASE_URL)%' } # 默认数据库连接
            - '@doctrine.dbal.second_connection' # 第二个数据库连接

services:
    doctrine.dbal.second_connection:
        class: Doctrine\DBAL\Connection
        factory: ['Doctrine\DBAL\DriverManager', 'getConnection']
        arguments:
            - { url: 'mysql://second_database_user:second_database_password@second_database_host:second_database_port/second_database_name' }

use Doctrine\DBAL\Connection;

class MyController extends AbstractController
{
    public function index(Connection $secondConnection)
    {
        $query = 'SELECT * FROM table_name';
        $result = $secondConnection->executeQuery($query)->fetchAll();

        // 处理查询结果...

        return $this->render('my_template.html.twig', [
            'data' => $result,
        ]);
    }
}