public function billsUser() { $user = Auth::user(); $result = DB::table('users')->where('users.id', $user->id)->leftjoin('courses', 'users.id', '=', 'courses.assignedOwner')->join('bills', 'courses.id', '=', 'bills.course_id')->select('bills.id')->get(['bills.id']); $billIds = array(); foreach ($result as $bill) { array_push($billIds, $bill->id); } $bills = Bill::findMany($billIds); return view('public.userBills')->with('bills', $bills); }