They show me a cent.
means that they showed you a penny piece, a cent.
They show me to a cent.
does not really make much sense.
They showed me to a seat.
means that they directed or conducted you to a seat, perhaps in a theater or concert house.
Please show me to a seat
is a request to be so conducted.
Other locations could be specified:
- He showed me to a table.
- He showed me to a post office.
- He showed me to the exit.
and each ocf these could be used in the "please show me to" form. If the object is instead a person or an animate being, as in:
- He showed me to the queen.
- He showed me to the audience.
- He showed me to a possible employer
it could mean that you were displayed, rather than conducted, to the queen, audience, or employer. But this form doesn't really make sense unless the object is a living being, or something that can perceive things. Perhaps:
- He showed me to the camera, which recorded my image.
- They showed the victim to the lions.
This form will often be ambiguous, because one cannot tell without additional context if the subject ("me" or "the victim" in the examples) is being conducted or displayed.
One of the comments is (a bit unclearly, perhaps) suggesting this form with an object of "a cent". But that only works if one assumes or pretends that a cent can see or at least perceive things, which normally it cannot.
The form "they show me to an X" only works as part of a present tense narratrion, a somewhat unusual form, such as:
They hear me knock. They open the door to me. They show me to the director's office.
This is possible, and grammatically correct, but sufficiently unusual as to feel a bit unnatural, in my view.