MySQL以米为单位计算距离ST_Distance_Sphere(g1, g2 [, radius]) mysql官网: https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html#function_st-distance-sphere https://www.it1352.com/1663704.html https://www.cnblogs.com/lxwphp/p/10024742.html geometry类型使用