根据经纬度计算距离并排序分页

$userItem = User::get($uid);

$lng = $userItem['longitude'];
$lat = $userItem['latitude'];
$EARTH = 6378.137; //地球半径
$PI = 3.1415926535898; //PI值

$model = new StoreOrder;

// 待接单

$map1 = [
            ['a.paid', '=', 1],
            ['a.status', '=',  0],
            ['a.refund_status', '=', 0],
            ['a.shipping_type', '=',  1],
            ['a.is_del', '=',  0],
            ['a.is_system_del', '=',  0],
];

$map2 = [
            ['a.paid', '=', 0],
            ['a.status', '=', 0],
            ['a.pay_type', '=', 'offline'],
            ['a.refund_status', '=', 0],
            ['a.shipping_type', '=', 1],
            ['a.is_del', '=', 0],
            ['a.is_system_del', '=', 0],
];

//根据司机经纬度和订单收货地址经纬度计算

$list_0 = $model->alias('a')->whereOr([$map1, $map2])->join('user_address ad', 'a.user_address_id = ad.id')
->field(['a.*', 'ad.latitude as user_address_latitude', 'ad.longitude as user_address_longitude', '(2 * ' . $EARTH . '* ASIN(SQRT(POW(SIN(' . $PI . '*(' . $lat . '-ad.latitude)/360),2)+COS(' . $PI . '*' . $lat . '/180)* COS(ad.latitude * ' . $PI . '/180)*POW(SIN(' . $PI . '*(' . $lng . '-ad.longitude)/360),2)))) as distance'])
->order('distance asc')
->page((int) $page, (int) $limit)->select()->toArray();