mysql> select * from sys_user_resource_rca where rca_id = 1095223;
+---------+---------+---------+
| id      | user_id | rca_id  |
+---------+---------+---------+
| 1095301 | 1104085 | 1095223 |
| 1095309 | 1104137 | 1095223 |
+---------+---------+---------+
2 rows in set (0.00 sec)

mysql> select id, email, is_deleted from sys_user where id in (1104085,1104137);
+---------+-------------------------+------------+
| id      | email                   | is_deleted |
+---------+-------------------------+------------+
| 1104085 | [email protected] |          1 |
| 1104137 | [email protected]   |       NULL |
+---------+-------------------------+------------+
2 rows in set (0.00 sec)