mysql - 在 MySQL 中选择直到

Question

我有这张表包含user_id和father_id。我想选择与直到值father_id相关联的所有 s并将它们以逗号分隔的格式存储。user_idfather_id = 0

桌子：network

select user_id, father_id from network where user_id = 1762;

user_id father_id
1762    1761

select user_id, father_id from network where user_id = 1761; -- resulting father_id from the first query

user_id father_id
1761    1760

select user_id, father_id from network where user_id = 1760; -- resulting father_id from the second query

user_id father_id
1760    0

在这个例子中，我想father_id通过father_id = 0使用结果father_id作为next user_id.

标签： mysqlsqlloopsdo-while