php计算两地之间的距离

        $data = input();
        $latitude = $data['latitude'];
        $longitude = $data['longitude'];
        $sql = "SELECT
    *,
    ROUND(
        6378.138 * 2 * ASIN(
            SQRT(
                POW(
                    SIN(
                        (
                            $latitude * PI() / 180 - lat * PI() / 180
                        ) / 2
                    ),
                    2
                ) + COS($latitude * PI() / 180) * COS(lat * PI() / 180) * POW(
                    SIN(
                        (
                            $longitude * PI() / 180 - log * PI() / 180
                        ) / 2
                    ),
                    2
                )
            )
        ) * 1000
    ) AS customer
FROM
    lists
ORDER BY
    customer ASC";
        $sql = Db::query($sql);//执行原生的sql
        return json(['data'=>$sql,'msg'=>'','code'=>0]);