UPDATE your_table AS t1
JOIN your_table AS t2 ON t1.parent_id = t2.id
JOIN your_table AS t3 ON t2.parent_id = t3.id
SET t1.pids = CONCAT(t2.id, ‘-’, t3.id)
WHERE t1.some_condition; – 根据需要添加条件
UPDATE your_table AS t1
JOIN your_table AS t2 ON t1.parent_id = t2.id
JOIN your_table AS t3 ON t2.parent_id = t3.id
SET t1.pids = CONCAT(t2.id, ‘-’, t3.id)
WHERE t1.some_condition; – 根据需要添加条件