如何选择Laravel 5中过去30天加入表用户和员工的数据

Question

recent_employees =DB::table('users.created_at')
        ->join('employees', 'users.id', '=', 'employees.user_id')

        ->select('users.id', 'name','created_at')
        ->where DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= 'created_at';
        ->get();

Answer 1

Try this

recent_employees =DB::table('users as u') ->join('employees as e', 'users.id', '=', 'employees.user_id')

    ->select('u.id', 'e.name','u.created_at')
    ->whereRaw('DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= 'created_at')
    ->get();