You can't do this type of query in FetchXML. As a general rule, any SQL query that can only be written using subqueries cannot be implemented via FetchXML.
Unfortunately there's no obvious way around this. You could write a plugin on the Execute method to intercept the results of a query, and change what is returned to the user, but it's fairly complex, and I've not found a good way to manage the paging numbers in this way