根据传入的坐标确定据指定坐标的距离,并按距离排序
其中40对应的是lat纬度,116.4对应的是lng经度,单位是米
select ROUND(ACOS(SIN((40 * PI()) / 180 ) *SIN((t1.latitude * PI()) / 180 )
+COS((40 * PI()) / 180 ) * COS((t1.latitude * PI()) / 180 ) *COS((116.4* PI()) / 180
- (t1.longitude * PI()) / 180 ) ) * 6371 *1000,2) as distance from sign_seller_info t1
order by if(isnull(distance),1,0) ,distance