在列中 status 有以下值： slider - sidebar - below - oncheck - later .
我想得到所有物品的清单，但首先是 status = slider 那么 sidebar 等等。
每个 status 组应按排序 date desc .
我试过了 UNION ```
$sql = "select * from posts where status = 'slider' union
select * from posts where status = 'sidebar' union
select * from posts where status = 'below' union
select * from posts where status = 'oncheck' union
select * from posts where status = 'later'
order by date desc";

结果-项目混乱（首先 `below` 那么 `slider` 再说一遍 `below` 等）
有什么帮助吗？