csapi/application/index/model/activity/ActivityOrderModel.php

<?php
namespace app\index\model\activity;
use app\index\model\BaseModel;

class ActivityOrderModel extends BaseModel
{
    protected $table='activity_order';
    protected $connection = 'db_activity';

    /**
     * 获取该活动订单
     * @param $activity_id
     * @param $limit
     * @param $field
     * @return array
     */
    public function getOrderListByActivityId($activity_id,$limit=10,$field="*"){
        $list = $this->field($field)->where([
            'activity_id'=>$activity_id,
            'status'=>0
        ])->order('activity_order_id desc')->limit($limit)->select();

        return $list;
    }
}