Or perhaps simpler:

select

db_name= d.name,

filename= f.name,

file_location= f.physical_name

from sys.master_filesf

join sys.databasesd on d.database_id = f.database_id

🙂