Answers for "add clause laravel"

laravel where and where

Table::where('Column', Value)->where('NewColumn', Value)->get();

when in larevel

$role = $request->input('role');

$users = DB::table('users')
                ->when($role, function ($query, $role) {
                    return $query->where('role_id', $role);
                })
                ->get();