Contoh Controller Search multi tabel berelasi di laravel

public function search(Request $request) {
    $search = $request->search;
    $posts = Post::where(function($query) use ($search) {
            $query->where('title', 'like', "%$search%")
                  ->orWhere('description', 'like', "%$search%");
        })
        ->orWhereHas('category', function($query) use ($search) {
            $query->where('name', 'like', "%$search%");
        })
        ->orWhereHas('user', function($query) use ($search) {
            $query->where('name', 'like', "%$search%");
        })
        ->get();

    return view('index', compact('posts', 'search'));
}