And that’s why graph databases. Practically, you always need to limit the recursion depth anyway (can’t show infinite depth on an UI), so you might be able to make do with postgre.