Linking nodes using views
This can be achieved with Entity reference and relationship


Create a views of studio.
Make a relationship of Entity reference with user and hardware information
Now when you select fields all the fields from user, studio and hardware will be available in the list.
Select those fields which you need. and that's it.