What is the real world equivalent of the people of Rohan

Don't know that there really was an equivalent. Perhaps the Mongol hoards that created the need for the Great Wall of China.
A group of early Germanic tribes were known for their horses and heavy cavalry, this is the group Tolkien used as his model.