alias('bonus_log') ->field('bonus_log.*, user.nickName, user.avatarUrl') ->with('region') ->join('user', 'user.user_id = bonus_log.user_id') ->where('bonus_id', '=', $bonus_id) ->order(['bonus_log.create_time' => 'desc', 'bonus_log.region_level' => 'desc']) ->paginate($limit); } }