组合查询语句
//根据查询条件,生成sql语句
$sqlArr[] = self::where($condition)
->where($whereTime)
->field(['(start_distance + end_distance) as total_distance','order_sn','rider_id','rider_profits','create_time'])
->buildSql();
//中间表把所有sql union 起来
$temp=Db::table('lb_order')
->field("(start_distance + end_distance) as total_distance,order_sn,rider_id,rider_profits,create_time")
->union($sqlArr)->buildSql();
//使用子查询构造新的查询,根据需求可增加分页条件
$data = Db::table($temp.'a')
->where($condition)
->where($whereTime)
->order("create_time desc")
->select();