Laravel get product in multiple category

Every products will have multiple category. The structure of DB as follow:

1. Product Table: category_ids //2,3,5
2. Category: id, title, etc.

This is my current way to get the product, which will join another table and get some data.

$products = Product::where('status', StatusConstant::PT_ACTIVE)
                                ->with(['joindraw' => function ($query){
                                        $query->where('user_id', $this->user->id);
                                }])->get();

I will need to have a page, with tabs to get the product in the respective category (tab). What's the most effective way to get it? My idea is to get the category and foreach the products which has the category id.

via Chebli Mohamed