MySQL怎么计算两坐标距离并排序

SELECT id,

       city,

       longitude,

       latitude,

       round(

                   (

                           st_distance(

                                   point(longitude, latitude),

                                   point(111.621094, 40.913513)

                               ) / 0.0111

                       ) * 1000

           )

           AS distance

FROM locationpoint

ORDER BY distance;