Questions like this are best handled using the standard tensor-based approach for the covariant formulation of classical electromagnetism. In this approach the electric and magnetic fields are combined into a single tensor as follows: $$ F_{\mu \nu }=\left(
\begin{array}{cccc}
0 & E_x & E_y & E_z \\
-E_x & 0 & -B_z & B_y \\
-E_y & B_z & 0 & -B_x \\
-E_z & -B_y & B_x & 0 \\
\end{array}
\right) $$
In your specific case there is only $B_z\ne 0$ so $$F_{\mu \nu }=\left(
\begin{array}{cccc}
0 & 0 & 0 & 0 \\
0 & 0 & -B_z & 0 \\
0 & B_z & 0 & 0 \\
0 & 0 & 0 & 0 \\
\end{array}
\right)$$
Now, you would like to see how this behaves in the charge's reference frame. The charge's reference frame is a rotating reference frame. So the transformation is $$t \rightarrow T$$$$ x \rightarrow X \cos(\omega T) - Y \sin(\omega T)$$$$
y \rightarrow Y \cos(\omega T) + X \sin(\omega T)$$$$ z \rightarrow Z$$ where the cyclotron frequency is $\omega$.
Applying this transformation we get $$F_{M N}=\left(
\begin{array}{cccc}
0 & X \omega B_z & Y \omega B_z & 0 \\
-X \omega B_z & 0 & -B_z & 0 \\
-Y \omega B_z & B_z & 0 & 0 \\
0 & 0 & 0 & 0 \\
\end{array}
\right)$$
Compare this last expression to the first expression. We see that in this frame there is now an E-field. This E-field is proportional to the B-field and the cyclotron frequency. Furthermore, this E-field is directed radially. So this field is a real electromagnetic centripetal force which counteracts the fictitious centrifugal force and allows the charge to remain at rest in this non-inertial rotating frame.
Edit: adding Mathematica code
Get["OGRe.m", Path -> NotebookDirectory[]]
TSetAllowOverwrite[True]
TNewCoordinates["Unprimed", {t, x, y, z}]
TNewCoordinates["Rotating", {T, X, Y, Z}]
TAddCoordTransformation[
"Unprimed" -> "Rotating", {t -> T,
x -> X Cos[\[Omega] T] - Y Sin[\[Omega] T],
y -> Y Cos[\[Omega] T] + X Sin[\[Omega] T], z -> Z}]
TNewMetric["Minkowski", "Unprimed", DiagonalMatrix[{-c^2, 1, 1, 1}], "\[Eta]"]
TShow@TNewTensor["EM tensor", "Minkowski",
"Unprimed", {1, 1},
{{0, -Ex, -Ey, -Ez},
{Ex, 0, -Bz, By},
{Ey, Bz, 0, -Bx},
{Ez,-By, Bx, 0}}, "F"]
TShow["EM tensor", {-1, -1}, "Unprimed"]
TShow["EM tensor", {-1, -1}, "Rotating"]
TShow@TNewTensor["EM tensor", "Minkowski",
"Unprimed", {1, 1},
{{0, -0, -0, -0},
{0, 0, -Bz, 0},
{0, Bz, 0, -0},
{0, -0, 0, 0}}, "F"]
TShow["EM tensor", {-1, -1}, "Unprimed"]
TShow["EM tensor", {-1, -1}, "Rotating"]