Laravel or MySQLi - Using Joins [Filter Categorie Product]

SELECT * FROM `products`
INNER JOIN `category_products` ON `category_products`.`product_id` = `products`.`id`
INNER JOIN `filter_options_products` ON `filter_options_products`.`product_id` = `products`.`id`
WHERE `category_products`.`category_id` = 2
AND `filter_option_id` IN (1,2,3)

if(!isset($request->filter_lists))
        {
            $products=Product::
                join('categorie_product','categorie_product.product_id','=','products.id')
                ->where('categorie_product.categorie_id',$request->categorie_id)
                ->select('products.*')
                ->get();
        }else{

            for ($i=0; $i < count($request->filter_lists); $i++) { 
                $product[$i]=Product::
                    join('categorie_product','categorie_product.product_id','=','products.id')
                    ->where('categorie_product.categorie_id',$request->categorie_id)
                    ->join('filter_product','filter_product.product_id','=','products.id')
                    ->whereIn('filter_product.filter_id',$request->filter_lists[$i])
                    ->select('products.*')
                    ->get();
            }

            if(count($product) == 1)
            {
                $products=$product[0];
            }else{
                

                for ($i=0; $i < count($product) ; $i++) { 
                    $arr[$i]=array();
                    for ($a=0; $a < count($product[$i]); $a++) { 
                        array_push($arr[$i],$product[$i][$a]['id']);
                    }
                }

                for ($i=1; $i < count($arr); $i++) { 
                    $arr[0]=array_intersect($arr[0], $arr[$i]);
                }

                $products=Product::whereIn('id',$arr[0])->get();
            }

        }

select pd.* from product as pd
left join filter as ft 
  on ft.pd_id = pd.id 
  and ft.category in ( ?1, ?2, ?3)
group by pd.id
having count(pd.id)=3

### --- vFilter ---- View in database
select ft.*, dt.ft_Type, dt.ref_op_or_cg, dt.ref_for_category_id,  
from filters as ft
inner join (
	select 'cg' as ft_Type, fc.category_id as ref_op_or_cg, fc.filter_id as ft_ID, fc.id ref_for_category_id, cp.product_id
	from filters_categories fc left join category_product cp on cp.category_id = fc.category_id
	union all
	select 'op' as ft_Type, id, filter_id, null, fop.product_id
	from filter_options as fo left join filter_options_product fop on fop.fileter_option_id = fo.id
) as dt on dt.ft_ID = ft.id

$sql="select pd.* from products pd
left join vFilter v
	on v.id = $request_filter_select_id ## อ้างอิงตาราง filters
	and (
		(
			v.ft_Type = 'cg'
			and
			v.ft_ID in (".implode(',', $request_filter_category).")) ## อ้างอิง category
		or
		(
			v.ft_Type = 'op' 
			and
			v.ft_ID in (".implode(',', $request_filter_option).")) ## อ้างอิง option
	)
	and pd.id = v.product_id
group by pd.id having count(ft.*)=".(count($request_filter_category)+count($request_filter_option);