Following Sakurai, I know how the Cartesian components of a tensor transform under rotation, in classical physics and also in quantum physics. For example, the Cartesian components of a vector change as $$V^{\prime}_i= R_{ij} V_j$$ and the Cartesian components of the corresponding vector operator transform according to $$\hat{D}^\dagger(R)\hat{V}_i\hat{D}(R)=R_{ij}\hat{V}_j.$$ This can be generalized to Cartesian components of tensors of higher ranks. In particular, the Cartesian components of a tensor of rank-$k$ transform under the rotation as$$T_{i_1i_2...i_k}^\prime=R_{i_1j_1}R_{i_2j_2}...R_{i_kj_k}T_{j_1j_2...j_k}$$ and the corresponding Cartesian components of the tensor operator transform under the rotation according to $$D^\dagger(R)T_{i_1i_2...i_k} D(R)=R_{i_1j_1}R_{i_2j_2}...R_{i_kj_k}T_{j_1j_2...j_k}.$$
Sakurai tells us how the spherical tensor operators $\hat{T}^{(k)}_q$ in quantum mechanics. A spherical tensor of rank-$k$ is a set of $(2k+1)$ operators whose components transform under rotation as (Sakurai) $$\hat{D}^\dagger(R) \hat{T}^{(k)}_q\hat{D}(R)=\sum\limits_{q'=-k}^{k}D_{qq'}^{(k)*}\hat{T}_{q'}^{(k)}$$ or $$\hat{D}(R) \hat{T}^{(k)}_q\hat{D}^\dagger(R)=\sum\limits_{q'=-k}^{k}D_{q'q}^{(k)}\hat{T}_{q'}^{(k)}.$$ where these $\hat{D}(R)$'s are unitary representations of $R\in SO(3)$ in the appropriate ket space of the quantum system.
But what is a spherical tensor $T^{(k)}_q$ (not a spherical tensor operator, $\hat{T}^{(k)}_q$) in classical physics? For irreducible spherical tensors of rank-$k$, I would expect that under rotation the following should be the case: $$T^{(k)}_q\stackrel{R}{\rightarrow} \sum_{q'=-k}^{k}C^{(k)}_{qq'}T^{(k)}_{q'}.$$ But if this is the case, how are the coefficients $C^{(k)}_{qq'}$ related to $R_{ij}$?