使用PHP Laravel 2019在postgres中连接来自不同数据库的2个或多个表

'connections' => [
    'postgres1' => [
        'driver' => 'pgsql',
        'host' => 'localhost',
        'port' => '5432',
        'database' => 'database1',
        'username' => 'username1',
        'password' => 'password1',
        'charset' => 'utf8',
        'prefix' => '',
        'schema' => 'public',
    ],

    'postgres2' => [
        'driver' => 'pgsql',
        'host' => 'localhost',
        'port' => '5432',
        'database' => 'database2',
        'username' => 'username2',
        'password' => 'password2',
        'charset' => 'utf8',
        'prefix' => '',
        'schema' => 'public',
    ],
    // 可以继续添加其他数据库连接配置...
],

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Table1 extends Model
{
    protected $connection = 'postgres1';
    protected $table = 'table1';
}

class Table2 extends Model
{
    protected $connection = 'postgres2';
    protected $table = 'table2';
}

$table1Data = Table1::all();
$table2Data = Table2::where('column', 'value')->get();