$users = DB::table('users') ->where('name', 'like', 'T%') ->get();
$data = DB::table('borrowers') ->join('loans', 'borrowers.id', '=', 'loans.borrower_id') ->select('borrowers.*', 'loans.*') ->where('loan_officers', 'like', '%' . $officerId . '%') ->where('loans.maturity_date', '<', date("Y-m-d")) ->get();
$camps = $field->camps()->where('status', 0)->where(function ($q) { $q->where('sex', Auth::user()->sex)->orWhere('sex', 0); })->get();
Table::where('Column', Value)->where('NewColumn', Value)->get();