$model = new CartModel;
$data = $model->alias('a')
->join('__RENDER__ b', 'a.goods_id = b.goods_id')
->join('__TYPE__ k', 'a.render_id = k.t_id')
->where('a.state', '<=', 4)
->where(('a.goods_attr_id'),'IN',function($query){
$query->table('gzy_render_att')->where('status',1)->field('att_value');
})
->where($where)
->order('buytime desc')
->paginate(config('paginate.list_rows'));
最佳答案