如何在Laravel语言中过滤相关模型

class User extends Model
{
    public function posts()
    {
        return $this->hasMany(Post::class);
    }
}

class Post extends Model
{
    public function user()
    {
        return $this->belongsTo(User::class);
    }
}

$user = User::find(1); // 假设用户ID为1
$posts = $user->posts; // 获取该用户的所有文章

$posts = Post::where('title', 'like', '%Laravel%')->get();

$posts = Post::where('title', 'like', '%Laravel%')
             ->where('status', 'published')
             ->get();

// 确保标题和状态字段存在且拼写正确
$posts = Post::where('title', 'like', '%Laravel%')
             ->where('status', 'published')
             ->get();

// 使用索引优化查询
$posts = Post::where('title', 'like', '%Laravel%')
             ->where('status', 'published')
             ->orderBy('created_at', 'desc')
             ->paginate(10); // 分页处理

use App\Models\Post;

// 获取所有标题包含“Laravel”且状态为“published”的文章
$posts = Post::where('title', 'like', '%Laravel%')
             ->where('status', 'published')
             ->orderBy('created_at', 'desc')
             ->paginate(10);

// 输出结果
foreach ($posts as $post) {
    echo $post->title . "\n";
}