Why did Aunt Bee move in with Andy and Opie?

Because Andy’s housekeeper, Rose, got married and moved away.