show relation table based on the parent table column in laravel

Question

I want to show the ProductAttributes relation based on the product's attribute_status column.

Here is my code:

Product::with('productImages', 'productReviews', 'user.vendors', 'subchildcategories', 'ProductAttributes')
    ->where('category_id', $request->category_id)
    ->where('products.status', 1)
    ->get();

Answer 1

Try this:

Product::where('category_id',$request->category_id)
    ->where('products.status',1)
    ->with('productImages', 'productReviews', 'user.vendors', 'subchildcategories', 'ProductAttributes')
    ->get();

Answer 2

$products = Product::with(['productImages', 'productReviews', 'user.vendors', 'subchildcategories', 'ProductAttributes'])
    ->where('category_id',$request->category_id)
    ->where('products.status',1)
    ->get()
    ->map(function ($product) {
        $product->productAttributes = $product->attribute_status == 1 ? $product->productAttributes : null;

        return $product;
    });