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);
}
