// 关联模型
namespace app\model\product\product;
/**
* @return \think\model\relation\HasOne
* 关联已预定表
*/
public function reserveOrder()
{
return $this->hasOne(StoreReserveOrder::class, 'product_id', 'id');
}
// 使用模型查询时传参
})->field($field)->with(['reserveOrder' => function($query) use ($where) {
$reserve_time = date('Y-m-d', $where['reserve_time']);
$query->where('reserve_time', $reserve_time)
->field('*, count(product_id) as count')
->group('product_id')
->find();
}])->select()->toArray();