Sql combine multiple rows into one row, PIVOT

User table Address table Expected query result
The query below can generated the expected result.
http://stackoverflow.com/questions/21118809/combine-multiple-rows-into-one-row-mysql