As we knew, in classic view folder and report are in a two-level structure. We can not create folder under folder in classic mode.
Using SOQL like (Select OwnerId,Id from Report / Select from Folder), we can get reports and folders, and display them in flat view.
Lightning has enabled nested folders as new feature. So it seems that the folder-report is no longer a flat structure.
Can we get this kind of relationship by SOQL?