Laravel实时聊天应用数据库设计与Seeder关联填充异常

我正在开发一款实时聊天（live-chat）应用，最初设计Message模型同时绑定发送方（Sender）与接收方（Receiver）关联，理论逻辑可正常运行，但执行数据库填充（seed）时出现异常：仅首个创建的用户可正常访问消息关联关系，其余用户关联全部失效。

相关实现代码 #

消息表迁移（Message Migration） #

public function up()
{
    Schema::create('messages', function (Blueprint $table) {
        $table->id();
        $table->timestamps();
        $table->text('content');
        $table->foreignUuid('from_id')->references('uuid')->on('users');
        $table->foreignUuid('to_id')->references('uuid')->on('users');
    });
}

用户表迁移（User Migration） #

$table->id();
$table->uuid('uuid')->unique();
$table->string('name');
$table->string('email')->unique();
$table->timestamp('email_verified_at')->nullable();
$table->string('password');
$table->string('profile')->default(public_path('images/default_profile.jpg'));
$table->rememberToken();
$table->timestamps();

消息模型（Message Model） #

class Message extends Model
{
    use HasFactory;
    protected $table = "messages";

    public function sender()
    {
        return $this->belongsTo(User::class, 'from_id');
    }
    public function receiver()
    {
        return $this->belongsTo(User::class, 'to_id');
    }
}

用户模型（User Model） #

public function sent()
{
    return $this->hasMany(Message::class, 'from_id');
}
public function received()
{
    return $this->hasMany(Message::class, 'to_id');
}
public function contacts()
{
    // 联系人关联逻辑未完整展示
}

数据填充逻辑（DatabaseSeeder） #

User::factory()->create([
    'name' => 'username',
    'email' => 'admin@admin.com',
    'password' => bcrypt('password')
]);
Message::factory()
    ->count(200)
    ->create();
User::factory()->count(10)->create();
$users = User::all();
$messages = Message::all();
User::all()->each(function ($user) use ($users) {
    do {
        $idsToAttach = $users->random(rand(1, 3))->pluck('id')->toArray();
        $idsToAttach = array_diff($idsToAttach, array($user->id));
    } while (count($idsToAttach) <= 0);
    $user->contacts()->attach(
        $idsToAttach
    );
});
$messages->each(function ($message) use ($users) {
    do {
        $sender = $users->random(1)->pluck('uuid');
        $receiver = $users->random(1)->pluck('uuid');

    } while ($sender[0] == $receiver[0]);
    $message->receiver()->associate(
        $receiver[0]
    );
    $message->sender()->associate(
        $sender[0]
    );
    $message->save();
});

故障原因 #

关联失效是三个问题叠加导致的：

• 填充顺序错误：先创建200条消息，再创建其余10个用户。消息首次创建时from_id、to_id取工厂默认值，几乎全部绑定到第一个创建的管理员账号。
• 关联定义不完整：from_id、to_id是指向users.uuid字段的外键，但所有belongsTo、hasMany关联都没有指定自定义所有者键，Eloquent默认会用users.id做关联匹配，非首个用户自然无法匹配到关联数据。
• 后续更新逻辑错误：associate()方法默认取关联模型的主键值写入外键，传入uuid值会导致字段值不匹配，关联绑定失败。

修复方案 #

1. 补全模型关联键定义 #

Message模型关联修改，明确指定关联使用uuid字段：

public function sender()
{
    return $this->belongsTo(User::class, 'from_id', 'uuid');
}
public function receiver()
{
    return $this->belongsTo(User::class, 'to_id', 'uuid');
}

User模型关联同步修改：

public function sent()
{
    return $this->hasMany(Message::class, 'from_id', 'uuid');
}
public function received()
{
    return $this->hasMany(Message::class, 'to_id', 'uuid');
}

2. 调整Seeder执行逻辑 #

调换创建顺序，先创建所有用户与联系人关联，再创建消息并直接绑定收发方，避免二次更新出错：

// 先创建全部用户
$admin = User::factory()->create([
    'name' => 'username',
    'email' => 'admin@admin.com',
    'password' => bcrypt('password')
]);
$otherUsers = User::factory()->count(10)->create();
$allUsers = $admin->merge($otherUsers);

// 创建联系人关联
$allUsers->each(function ($user) use ($allUsers) {
    do {
        $contactUuids = $allUsers->random(rand(1,3))->pluck('uuid')->toArray();
        $contactUuids = array_diff($contactUuids, [$user->uuid]);
    } while (count($contactUuids) <= 0);
    $user->contacts()->attach($contactUuids);
});

// 最后创建消息，直接绑定收发方uuid
Message::factory()
    ->count(200)
    ->make()
    ->each(function ($message) use ($allUsers) {
        do {
            $sender = $allUsers->random();
            $receiver = $allUsers->random();
        } while ($sender->uuid == $receiver->uuid);
        $message->from_id = $sender->uuid;
        $message->to_id = $receiver->uuid;
        $message->save();
    });

调整完成后重新执行数据填充，所有用户的消息关联即可正常访问。

内容的提问来源于stack exchange，提问作者coderz