Fixing table relationships

Hello Everyone,

The current relationships among my tables are not alloiwng me to derive a table visualization with my desired output. Let me walk you through my tables and what I've got so far so you can understand what I want to achieve.

I have 4 tables:

1) Accounts Table

2) User Table 

3) Risk Accounts Table

4) Transactions Table

The Accounts and User Table are related (many to 1) using User ID as the key. The Accounts and Risk Accounts table are related (1 to many) using Account ID as the key. And my Transactions and Accounts table are related (Many to 1) using Account ID as the key. 

Using these relationships I get the following table visualization:

But this is not what I want to see. Basically if a client appears in the Risk Accounts table, I would like to see the transactions made by all of the accounts of that client (even those that do no appear in the Risk Accounts table). So in the following table I also get transactions for Account ID 2 and 6 becuase they are related to User ID A and D. The table would look like this:

Let me know if you understood what I'm trying to achieve. Any help would be appreciated. 

Thanks