Retrieving All Names of Parents for a Given ID in SQL Using Recursive Queries

How to Extract Data from Lists of Different Hierarchical Levels Using Recursive Functions in R