如何在更少的SQL查询中执行复杂的API授权?

I'm trying to add an authorization layer to an API, and the current design I have results in more SQL queries than it feels like should be required, so I'm wondering how I can simplify this.I'm trying to add an authorization layer to an