laravel empty网站3.1导出，查询给出带有join的空excel

composer require maatwebsite/excel

php artisan make:export EmptyJoinExcel --model=User

<?php

namespace App\Exports;

use App\Models\User;
use Maatwebsite\Excel\Concerns\FromQuery;
use Maatwebsite\Excel\Concerns\Exportable;
use Maatwebsite\Excel\Concerns\WithHeadings;

class EmptyJoinExcel implements FromQuery, WithHeadings
{
    use Exportable;

    public function query()
    {
        // 编写查询逻辑，包括join操作
        return User::query()
            ->join('orders', 'users.id', '=', 'orders.user_id')
            ->whereNull('users.name'); // 这里假设我们要查询name为空的用户
    }

    public function headings(): array
    {
        // 定义Excel表头
        return [
            'ID',
            'Name',
            'Email',
            'Created At',
            'Updated At',
        ];
    }
}

<?php

namespace App\Http\Controllers;

use App\Exports\EmptyJoinExcel;
use Maatwebsite\Excel\Facades\Excel;

class UserController extends Controller
{
    public function exportEmptyJoinExcel()
    {
        return Excel::download(new EmptyJoinExcel(), 'empty_join_excel.xlsx');
    }
}

Route::get('/export-empty-join-excel', [UserController::class, 'exportEmptyJoinExcel']);