select `person`.`id`,`person`.`name`,`person`.`age`,`person`.`address_id`,(select `address`.`street` from `address` where `person`.`address_id` = `address`.`id` ) `address`,`_a`.`city` from `person` inner join `address` as `_a` on `_a`.`id` = `person`.`address_id` []