I will try to reply without going into math first.
I think your mind is kinda confused, but relativity often is confusing.
You are speaking of stationary observer, but in relativity an observer is stationary only with respect to some reference frame, there is no absolutely stationary observer. This is one of the fundamental principles of special relativity, when you say the observer is standing still you need to say also in which reference frame.
Now consider a electrostatically charged wire of infinite length with a constant linear density of charge. This produces and cylindrically symmetric electric field that can easily be calculated by means of Gauss theorem and I leave the computation to you as an exercise. When we are saying the wire is charged we are stating that in our reference frame the charges in the wire are not moving, hence we are standing still with respect to the charges.
Say the wire is along the z axis and we start moving in the negative z direction at constant speed, i.e. we perform a Lorentz boost in the negative z direction. The charges in our reference frame are moving in the positive z direction, hence in the observers (us) reference frame what earlier was a charge density is now a current density. This current density sources a magnetic field. In this scenario we are not standing still with respect to the charges. Even though you might be looking at a wire standing still in the lab, hence still with respect to the lab you are not necessarily still wrt the charges.
Mathematically all of this is encoded in the transformation laws for the 4-current and electromagnetic field strength tensor