Multi-level Hierarchy from Parent Child Columns

Hi, I have a table with folder data in it. In some instances there are multiple levels of sub-folders, but the data comes through in the form of [folderId] and [parentId] so where a folder might sho...