On the $q$-Hermite polynomials and their relationship with some other families of orthogonal polynomials