From the above setup, it seems that there are two schemas involved. One which contains email addresses and the other one which contains segment information. There is a one to many link between the two schemas.
Use a query to fetch email and email1 records.
Feed them to an Enrichment and select Data linked to the filtering dimension menu. It will then show you two options, this time select Data linked to the filtering dimension.
Proceed through the wizard, select how many records per email you wish to fetch from segment schema.
The output of this Enrichment will have the data in the format you need.