如何获取最近的对话Laravel

CREATE TABLE conversations (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL
);

CREATE TABLE messages (
    id INT PRIMARY KEY AUTO_INCREMENT,
    conversation_id INT,
    content TEXT NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (conversation_id) REFERENCES conversations(id)
);

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Conversation extends Model
{
    public function messages()
    {
        return $this->hasMany(Message::class);
    }
}

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Message extends Model
{
    public function conversation()
    {
        return $this->belongsTo(Conversation::class);
    }
}

use App\Models\Conversation;

$recentConversations = Conversation::with(['messages' => function ($query) {
    $query->latest()->limit(1);
}])->get();

$recentConversations = Conversation::with(['messages' => function ($query) {
    $query->latest()->limit(1);
}])->paginate(10); // 每页显示10个对话