如何在sql中检查当前位置是否在我们的服务范围内？

-- 创建示例表
CREATE TABLE service_areas (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    boundary GEOMETRY(Polygon, 4326)
);

CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    location GEOMETRY(Point, 4326)
);

-- 插入示例数据
INSERT INTO service_areas (id, name, boundary) VALUES
(1, 'Service Area 1', ST_GeomFromText('POLYGON((0 0, 0 10, 10 10, 10 0, 0 0))'));

INSERT INTO users (id, name, location) VALUES
(1, 'User 1', ST_GeomFromText('POINT(5 5)')),
(2, 'User 2', ST_GeomFromText('POINT(15 15)'));

SELECT u.id, u.name, sa.name AS service_area
FROM users u
JOIN service_areas sa ON ST_Within(u.location, sa.boundary);