Mysql Query Results Sort, name Field Has Chinese Names and English Names, How to Sort Names in a-z Order

  mysql, question

1. The name field is used to store the customer’s name. The query results need to be sorted by the phonetic alphabet of the last name. Now there is a problem.
Names include both Chinese and English names, such as Zhang San, Li si, Jaewon Park and Lao Wang
In this way, the English name will always come first
I used the following sentence for sorting
CONVERT(NameUSING gbk ) COLLATE gbk_chinese_ci
图片描述

How can the first letter of English be sorted by Pinyin?

Thank you.
Only use mysql to solve, Chinese and English mixed according to A-Z order, I have no way

One of my small thoughts is to add a column, convert Chinese into pinyin, and then sort by letter.