mysql 循环取值 重复循环_在while循环中重复Mysql数组值

我有一个查询，其中输出来自独特的选项获得循环belp查询与MySQL转储重复

CREATE TABLE `txt` (

`option` varchar(10) NOT NULL,

`username` varchar(100) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `txt` VALUES ('a', 'ashok');

INSERT INTO `txt` VALUES ('a', 'sachin');

INSERT INTO `txt` VALUES ('b', 'parvez');

query:

$result = mysql_query("SELECT option, name from txt");

while ($row = mysql_fetch_array($result)) {

$option = $row['option'];

$name = $row['username'];

$array[$option] = $name;

}

print_r($array);实际产出：

Array ( [a] => Array ( [name] => Array ( [0] => ashok [1] => sachin )

Array ( [b] => Array ( [name] => Array ( [0] => ashok [1] => sachin [2] => parvez)预期产出：

Array ( [a] => Array ( [name] => Array ( [0] => ashok [1] => sachin )

Array ( [b] => Array ( [name] => Array ( [0] => parvez)请告诉我我在这个查询中犯了什么错误