SQL Server - 从两个连接的表数据上下文中选择一个列

Let's say that I need to find all persons that are enabled users of a specific registration type of a person... And I want the PersonId of the user, as well as the related registration's person. A person can have multiple registrations, multiple persons, and multiple users.Let's say that I need to find all persons that