The Solenoidal Tracker at RHIC (STAR) experiment takes an advantage of its excellent tracking and particle identification capabilities at mid-rapidity to explore the properties of strongly interacting QCD matter created in heavy-ion collisions at RHIC. In these proceedings, we present the latest measurements of $J/\psi$ and $\Upsilon$ meson production in various collision systems performed by the STAR experiment. The quarkonium measurements in p+Au collisions can help quantify the cold nuclear matter effects, while the measurements in A+A collisions provide the opportunity to explore the balance of dissociation and regeneration contributions at RHIC energies. Furthermore, a significant excess of $J/\psi$ production at very low $p_{T}$ in peripheral A+A collisions is presented, which points to evidence of a coherent photoproduction in hadronic heavy-ion collisions.