很简单:

SELECT DISTINCT name FROM info WHERE status = 1 ORDER BY id

SQL 关键字 DISTINCT 可以解决问题.

The SQL keyword DISTINCT does the trick.