yii2框架 mysql两个点的经纬度计算距离排序查询

$query = Location::find()->select(['id', 'name'])->addSelect([
    'distance' => "ST_DISTANCE(POINT(:latitude, :longitude), POINT(latitude, longitude))",
])->orderBy('distance')->params([
    ':latitude' => $targetLatitude, // 目标纬度
    ':longitude' => $targetLongitude, // 目标经度
]);
 
// 输出查询结果
foreach ($query->all() as $result) {
    echo $result['id'] . ": " . $result['name'] . ", Distance: " . round($result['distance'], 2) . "\n";
}