THINKPHP SQL计算经纬度,获取最新地址
$sql = "SELECT a.*,b.title FROM (SELECT ROUND(6378.138*2*ASIN(SQRT(POW(SIN(($lat*PI()/180-`lat`*PI()/180)/2),2)+COS($lat*PI()/180)*COS(`lat`*PI()/180)*POW(SIN(($lng*PI()/180-`lng`*PI()/180)/2),2)))*1000) AS distance, dz, aid FROM ".PREFIX."sites_content ) as a INNER JOIN ".PREFIX."archives b ON b.aid = a.aid WHERE a.distance <= 5000 Order By distance ASC";
$res = Db::query($sql);