select 子查询?

->addSelect(['method_time' => function ($query) {
    $query->select('created_at')
        ->from('customer_method')
        ->whereColumn('method_id', 'apply.id')
        ->where('customer_method.table','apply')
        ->where('customer_method.follow_method',59)
        ->orderBy('created_at', 'desc')
        ->limit(1);
}])

orderby 子查询

return User::orderBy(function ($query) {
? ? $query->select('created_at')
? ? ? ? ->from('logins')
? ? ? ? ->whereColumn('user_id', 'users.id')
? ? ? ? ->latest()
? ? ? ? ->limit(1);
})->get();

from 子查询

return DB::table(function ($query) {
? ? $query->selectRaw('sum(amount) as total')
? ? ? ? ->from('donations')
? ? ? ? ->groupBy('user_id');
}, 'donations')->avg('total');