Inactive relationships

Hi everyone,

I have two tables. One is user, one is approval process.
In the approval, there are requesters and approvers.
I want to connect these two tables so one of them will be inactive.

What I want to do is viewing the visual by the specific requester, another visual by approver like below in BI.

For example, I want to get the record of user A.

How can I do this?

Thanks!