如何使用左连接添加where子句

I have written a code to retrieve the city, email, street and other details of the customers from the table order_address the issues here is for every order there are two rows where for one row the I have written a code to retrieve the city, ema