A photon always moves at the speed of light $c$, so one can never be in the same frame of reference. What causes the speed of light to be slower in a medium is the interaction with this medium. This is explained in more detail here:
As the wave moves through a medium, it intersects with (usually) the electrons, causing them to vibrate. That vibration does not exactly follow the wave: the E field causes a force, which causes an acceleration, which builds to velocity. That motion of charge causes the reradiation of another, weaker, delayed wave. The combination of the original wave and the reradiated one results in the overall wave being a bit delayed. The more material traversed, the more it’s delayed. In that sense, it’s showing a slower velocity: the more material it goes through, the longer it takes to get there.
(from Bob Jacobsen's answer)
I am by far no expert, but I like the way it is explained above – basically (and probably very simplified), a photon/the electromagnetic wave will travel at $c$ between the individual atoms, but gets absorbed and re-emitted when interacting with the atoms. The time delay between absorption and emission is what causes the overall decrease in velocity.
For more information, you may want to refer to What is the mechanism behind the slowdown of light/photons in a transparent medium? and What really causes light/photons to appear slower in media?
So to answer your question, one cannot make any statements of one would see if the relative velocity of a photon was $0$ because that is not possible (since a photon has no rest frame)