INSERT INTO closures (ancestor, descendant, pathlength)
SELECT ancestor, id, pathlength+1
FROM closures
JOIN nodes ON parent_id = descendant

UNION ALL

SELECT id, id, 0
FROM closures
JOIN nodes ON parent_id = descendant