如何在Laravel中使用基于subdomein的多个数据库

Route::domain('db1.example.com')->group(function () {
    // 定义与db1相关的路由
});

Route::domain('db2.example.com')->group(function () {
    // 定义与db2相关的路由
});

DB_CONNECTION=db1
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=db1
DB_USERNAME=root
DB_PASSWORD=

DB_CONNECTION=db2
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=db2
DB_USERNAME=root
DB_PASSWORD=

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class User extends Model
{
    protected $connection = 'db1';
}

namespace App\Http\Controllers;

use Illuminate\Support\Facades\DB;

class UserController extends Controller
{
    public function index()
    {
        $users = DB::connection('db2')->table('users')->get();
        // 处理查询结果
    }
}