mysql数组存入数据库

INSERT INTO table_name (array_column) VALUES ('["value1", "value2", "value3"]');

$array = ['value1', 'value2', 'value3'];
$serialized_array = serialize($array);
INSERT INTO table_name (array_column) VALUES ('$serialized_array');

CREATE TABLE main_table (
    id INT PRIMARY KEY,
    name VARCHAR(255)
);

CREATE TABLE related_table (
    id INT PRIMARY KEY,
    main_id INT,
    value VARCHAR(255),
    FOREIGN KEY (main_id) REFERENCES main_table(id)
);

INSERT INTO main_table (id, name) VALUES (1, 'example');
INSERT INTO related_table (id, main_id, value) VALUES (1, 1, 'value1'), (2, 1, 'value2'), (3, 1, 'value3');

SELECT JSON_EXTRACT(array_column, '$') AS array FROM table_name;

$result = mysqli_query($conn, "SELECT array_column FROM table_name WHERE id = 1");
$row = mysqli_fetch_assoc($result);
$array = unserialize($row['array_column']);

SELECT * FROM related_table WHERE main_id = 1;