解决办法:(排序字段+0)
SELECT
a.child_id AS childId,
a.child_logo AS childLogo,
a.child_name AS childName,
a.child_no AS childNo,
b.gender,
a.add_time AS ADDTIME,
a.status,
IF(c.add_by=100000,'true','false') AS isOwner
FROM class_child_relation_tb a
JOIN child_tb b ON b.id=a.child_id
JOIN class_tb c ON c.id=a.class_id
WHERE a.class_id=100001
AND a.status!=3 AND a.status!=4 AND a.status!=5
ORDER BY a.child_no+0 ASC
上述代码的 a.child_no+0 即是。