1.全等查询
$query->whereJsonContains('condition', ['level'=>$params['join_level']]);
// 备注:condition数据:[{"fee": 1000, "level": 0, "point": "1", "other_name": "全部"}]
2.like 查询
$query->where('service_subscribe_order.snapshot->service->service_name', 'LIKE', "%{$keyword}%");
// 备注:snapshot结构:{"service":{"service_name":"aa"}}
3.in 查询
$query->whereIn('service_subscribe_order.snapshot->service->id',[11111]);
// 备注:snapshot 结构:{"service":{"id": 11111}}