select round(6378.138*2*asin(sqrt(pow(sin( (latitude*pi()/180-34.2238420000*pi()/180)/2),2)+cos(latitude*pi()/180)*cos(34.2238420000*pi()/180)* pow(sin( (longitude*pi()/180-108.8881040000*pi()/180)/2),2)))*1000) as a from user_location
换成自己的就oKle