The train hard sleeper ticket I bought is from Chengdu to Xinjiang Kuqa, but my family is in Mianyang Santai, can I get on the train from Mianyang Station.

If the train you bought the ticket for will pass through Mianyang Station and will stop, then you can get on the train at Mianyang Station.