获取与表中另一个ID相关的ID，然后使用该ID从另一个表中获取信息

I am going to try and explain this the best way I can. I have a table called albumAccess which has the following fields : id, albumID, userID, and permission. I am going to try and explain this the best way