In recent years, several deviations from the Standard Model predictions in semileptonic decays of $B$-meson might suggest the existence of new physics which would break the lepton-flavour universality. In this work, we have explored the possibility of using muon sneutrinos and right-handed sbottoms to solve these $B$-physics anomalies simultaneously in $R$-parity violating minimal supersymmetric standard model. We find that the photonic penguin induced by exchanging sneutrino can provide sizable lepton flavour universal contribution due to the existence of logarithmic enhancement for the first time. This prompts us to use the two-parameter scenario $(C^{rm V}_9, , C^{rm U}_9)$ to explain $b to s ell^+ ell^-$ anomaly. Finally, the numerical analyses show that the muon sneutrinos and right-handed sbottoms can explain $b to s ell^+ ell^-$ and $R(D^{(ast)})$ anomalies simultaneously, and satisfy the constraints of other related processes, such as $B to K^{(ast)} u bar u$ decays, $B_s-bar B_s$ mixing, $Z$ decays, as well as $D^0 to mu^+ mu^-$, $tau to mu rho^0$, $B to tau u$, $D_s to tau u$, $tau to K u$, $tau to mu gamma$, and $tau to mumumu$ decays.