How to get parent folder for each list

What I’m trying to do

I am trying to create a dataview which queries all notes in my vault with a specific tag. So I have

SELECT *
FROM #tag-name

This gives me a list of files which contain my tag. However where I would have these tags, I have a folder structure for issueName/_Info and the _Info file contains the tag. What I need is for this query to not return the file name, but the parent folder’s name

Is there a way to do this?