laravel 子查询

最新推荐文章于 2024-02-06 12:08:08 发布

郭周园

最新推荐文章于 2024-02-06 12:08:08 发布

阅读量2.7k

点赞数

文章标签： laravel mysql php 数据库 sql

本文链接：https://blog.csdn.net/qvanminpiao/article/details/120018362

版权

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');