Sofie vs Sofia

...and they lived happily ever after.... but what happened to the villainess?? ... usually the story began with a lovable princess that will be love by all the characters.
Sofia is the villainess in the book , she is known as the dark one character who will be hate by all . She is vicious and ambitious and crazy about the male lead. She is cruel and and selfish and be poisoned by the last chapter but wait ,the twist is yet to come when a real person entered the book and live as Sofia? .... will she survived or to be killed in the end as stated in the book...