在laravel中搜索特定公里范围内的用户

// 在 User 模型中添加经纬度字段
class User extends Model
{
    protected $fillable = ['latitude', 'longitude'];
}

// 在控制器中处理搜索请求
public function searchUsersWithinRange(Request $request)
{
    $targetLatitude = $request->input('latitude');
    $targetLongitude = $request->input('longitude');
    $searchRange = 10; // 搜索范围，单位为公里

    $users = User::select('id', 'name', 'latitude', 'longitude')
        ->selectRaw(
            "(6371 * acos(cos(radians($targetLatitude)) 
            * cos(radians(latitude)) 
            * cos(radians(longitude) 
            - radians($targetLongitude)) 
            + sin(radians($targetLatitude)) 
            * sin(radians(latitude)))) AS distance"
        )
        ->having('distance', '<=', $searchRange)
        ->orderBy('distance')
        ->get();

    return response()->json($users);
}