Use transactions in which :
1- Begin transaction
2- insert the user with null address, get its insert(ed)ID
3- insert the address with user_id (from above), get the insert(ed)ID of the address
4- Update user record, setting address_id to the obtained insert(ed)ID from above.
5- Commit Transaction