How to make such a request using laravel?

Question

MySQL

Hello, help me understand.
Made a query to the database using DB::select()
part of the code:

class ProductsController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $products = Products::all();
        $categories = DB::table('categories')->get();
        //$categoriesRelationship = DB::table('categories_relationship')->get();
        $categoriesRelationship = DB::select("SELECT
                                            categories.category_filter_by AS 'catFilterBy',
                                            products.id AS 'productID'
                                          FROM
                                            categories, products, categories_relationship
                                          WHERE
                                            categories.category_id = categories_relationship.category_id
                                          AND
                                            products.id = categories_relationship.object_id"
                                        );

        return response()->json([
            'productsList' => $products,
            'categories' => $categories,
            'categoriesRelationship' => $categoriesRelationship,
        ]);
    }
}

getting $categoriesRelationship done right?
Is there any other way to make such a request using laravel methods?
Thanks

Answer 1

DB::table('products')
   ->select(['products.id', 'categories.category_filter_by'])
   ->join('categories_relationship', 'products.id', '=', 'categories_relationship.object_id')
   ->join('categories', 'categories.category_id', '=', 'categories_relationship.category_id')
   ->get();