1对多关系的表，获取1表的20条数据，同时获取多表最新几条数据

[clms2]

获取用户的订单时只获取最新的2条:

$dbprefix = config('database.connections.mysql.prefix');
$orderCount = 2;
$users = User::with(['order' => function($q) use($dbprefix, $orderCount){    
    $q->select(['o.order_id','o.user_id','o.order_sn'])
    ->leftJoin('order as o', function($join){
        $join->on('o.user_id', '=', 'order.user_id')->on('order.order_id', '>=', 'o.order_id');
    })
    ->groupBy('o.user_id')
    ->groupBy('o.order_id')
    ->having(DB::raw("count({$dbprefix}o.order_id)"), '<=', $orderCount);
}])->limit(20)->get();