@php use Illuminate\Support\Facades\DB; $MasterItems = DB::table('tmstmproductsize')->join('tmstmproduct','tmstmproductsize.xvpdtcode','=','tmstmproduct.xvpdtcode'); if(isset($WhereType) && isset($ValueWhere) && isset($operator)){ $MasterItems->where($WhereType,$operator,$ValueWhere); } $MasterItems = $MasterItems->orderBy('tmstmproductsize.xvpdtcode','desc')->get()->toArray(); //dd($MasterItems); //foreach ($MasterItems as $item){ // $item->size = DB::table('tmstmproductsize') // ->where('xvpdtcode','=',$item->xvpdtcode) // ->get()->toArray(); //} @endphp