inner join

$query = $db->prepare("UPDATE tw_user INNER JOIN tw_alamat ON (tw_user.user_id = tw_alamat.user_id) SET tw_user.user_username = :user_username, tw_user.user_name = :user_name, tw_user.user_tanggal_lahir = :user_tanggal_lahir, tw_user.user_first_name = :user_first_name, tw_user.user_last_name = :user_last_name, tw_alamat.alamat = :alamat, tw_alamat.alamat_kota = :alamat_kota, tw_alamat.alamat_state = :alamat_state, tw_alamat.alamat_post = :alamat_post, tw_alamat.alamat_negara = :alamat_negara WHERE tw_user.user_id = :user_id AND tw_alamat.user_id = :user_id");

$query->BindParam(':user_id', $user_id);
$query->BindParam(':user_name',$user_name)
$query->BindParam(':user_tanggal_lahir',$user_tanggal_lahir);
$query->BindParam(':user_first_name',$user_first_name);
$query->BindParam(':user_last_name', $user_last_name);
$query->BindParam(':user_email', $user_email);
$query->BindParam(':user_tlp',$user_tlp);
$query->BindParam(':user_password', $user_password);
$query->BindParam(':alamat', $alamat);
$query->BindParam(':alamat_kota', $alamat_kota);
$query->BindParam(':alamat_state', $alamat_state);
$query->BindParam(':alamat_post', $alamat_post);
$query->BindParam(':alamat_negara', $alamat_negara);
$query->execute();