我正在尝试对产品和3个相关表进行搜索查询这是我迄今为止所做的：

$products = Product::with(['categories', 'tags','stags'])

        ->when(request('search'), function($query) {
            return $query->where('title','like','%' . request('search') . '%');
        })

        ->when(request('category_id'), function ($query) {
            return $query->whereHas('categories', function ($q) {
                return $q->where('id', request('category_id'));
            });
        })

        ->orderBy('place' , 'desc')
        ->paginate(12);

问题是，当我为stag和tag添加查询时：

$products = Product::with(['categories', 'tags','stags'])

        ->when(request('search'), function($query) {
            return $query->whereHas('tags', function ($q) {
                return $q->where('name', request('search'));
            })->orWhereHas('stags', function ($q) {
                return $q->where('name', request('search'));
            })->orWhere('title','like','%' . request('search') . '%');
        })

        ->when(request('category_id'), function ($query) {
            return $query->whereHas('categories', function ($q) {
                return $q->where('id', request('category_id'));
            });
        })

     

        ->orderBy('place' , 'desc')
        ->paginate(12);

Laravel忽略了我的category_id查询！