$EARTH=6378.137; //地球半径
$PI=3.1415926535898; //PI值
$lng = $this->request->request('longitude','112.57484');
$lat = $this->request->request('latitude','37.80680');
$list = $this->model
->where($where)
->field("*,(2 * $EARTH* ASIN(SQRT(POW(SIN($PI*(".$lat."-lat)/360),2)+COS($PI*".$lat."/180)* COS(lat * $PI/180)*POW(SIN($PI*(".$lng."-lng)/360),2)))) as juli")
->order('juli ASC')
->paginate($limit);
CREATE TABLE `fa_delivery_goods` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称',
`cat_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '类别',
`addtime` int(11) NOT NULL DEFAULT '0',
`