tp5.1根据经纬度测距并排序，获取附近多少公里内的数据

$order = ['distance' => 'asc']; // 按距离排序
$this->lat = '24.88513100'; // 用户经度
$this->lon = '102.82413200';//用户纬度

$workerAll = $this->user
            ->field("id,name,headimg,lat,lon,order_accept_num,telephone,topworktype_id,busy_status,(6378.138 * 2 * asin(sqrt(pow(sin((lat * pi() / 180 - " . $this->lat . " * pi() / 180) / 2),2) + cos(lat * pi() / 180) * cos(" . $this->lat . " * pi() / 180) * pow(sin((lon * pi() / 180 - " . $this->lon . " * pi() / 180) / 2),2))) * 1000) as distance")
            ->where($where)
            ->order($order)
            ->page($page, $pageSize)->select();

接着就得到了，这里显示的米，单位根据自己需要来转换

			{
				"id": 212,
				"headimg": "",
				"orderAcceptNum": 1,
				"worktypeId": 493,
				"worktypeText": "综合工",
				"busyStatus": 0,
				"lon": "102.82409200",
				"lat": "24.88512400",
				"distance": "4.11m"
			},
			{
				"id": 2,
				"headimg": "",
				"orderAcceptNum": 0,
				"worktypeId": 1,
				"worktypeText": "木工",
				"busyStatus": 0,
				"lon": "0.00000000",
				"lat": "0.00000000",
				"distance": "11311.84km"
			}

单位转换

// 当距离小于1km,单位显示米
 $postData["distance"] = round($worker->distance / 1000, 2) < 1 ? round($worker->distance, 2) . 'm' : round($worker->distance / 1000, 2) . 'km'; 

根据当前坐标查询5公里以内的信息，加入having

$workerAll = $this->user
            ->field("id,name,headimg,lat,lon,order_accept_num,telephone,topworktype_id,busy_status,(6378.138 * 2 * asin(sqrt(pow(sin((lat * pi() / 180 - " . $this->lat . " * pi() / 180) / 2),2) + cos(lat * pi() / 180) * cos(" . $this->lat . " * pi() / 180) * pow(sin((lon * pi() / 180 - " . $this->lon . " * pi() / 180) / 2),2))) * 1000) as distance")
            ->where($where)
            ->group('id')
            ->having($having)
            ->order($order)
            ->page($page, $pageSize)->select();