子查询返回多列 - 或近似

I have an interesting problem, however I don't know quite how to articulate it better than saying I have a subquery that needs to return multiple columns. PostgreSQL throws an error when I attempt to do this, so while my SQL looks somewhat logically sound to me - obviously there is a better way to do this. I'm attempting to merge user permissions into one table (hoping to throw this in to a view or even a "materialized view" of sorts). Here are my tables:I have an interesting problem, however I don't