We want to get the user's address for each ordered pizza. How might we achieve that?

By joining the tables, since address and pizza are on different tables.