显示具有特定标签或类别的帖子

$posts = Post::leftJoin('post_tags', 'post_tags.post_id', '=', 'posts.id')
             ->leftJoin('post_routes', 'post_routes.post_id', '=', 'posts.id')
             ->where('name', $tagName)
             ->where('route', $routeName)
             ->get();

Querying Relationship Existence . 因此,您可以:

$posts = Post::whereHas('tags', function ($tags) use ($tagName) {
        $tags->where('name', $tagName);
    })
    ->whereHas('ORMRoute', functions ($routes) use ($routeName) {
        $routes->where('route', $routeName);
    })
    ->get();