Ordering Mysql items multiple time in a query

Hint: below php statement

$query="select * from question_category_info where q_parent_category_id='$parent_id' ORDER BY priority DESC, q_category_name ASC";