SQL 基于已有经纬度筛选附近的人

$longitude = 1111111;
$latitude = 2222222;

SELECT *,(st_distance (point ($longitude, $latitude),point(longitude,latitude) ) *111195) AS distance from `table` where `statue`=0 and `sort`='$sort' ORDER BY distance ASC LIMIT 30;"