如何使用Laravel在DataTable中添加列并从数据库中返回值

// 创建数据库表的迁移文件
php artisan make:migration create_users_table --create=users

// 生成模型文件
php artisan make:model User

Route::get('/users', 'UserController@index');

namespace App\Http\Controllers;

use App\User;

class UserController extends Controller
{
    public function index()
    {
        $users = User::all();
        return view('users.index', compact('users'));
    }
}

<table id="users-table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Name</th>
            <th>Email</th>
            <th>Created At</th>
        </tr>
    </thead>
</table>

<script>
    $(document).ready(function() {
        $('#users-table').DataTable({
            processing: true,
            serverSide: true,
            ajax: '/users/data',
            columns: [
                { data: 'id', name: 'id' },
                { data: 'name', name: 'name' },
                { data: 'email', name: 'email' },
                { data: 'created_at', name: 'created_at' }
            ]
        });
    });
</script>

use DataTables;

public function getData()
{
    $users = User::select(['id', 'name', 'email', 'created_at']);
    return DataTables::of($users)->make(true);
}

Route::get('/users/data', 'UserController@getData');