grouping runs data

sql experts,

is there an fit proceed organisation runs information together controlling sql?

or going some-more fit slight information code.

for instance i have following data:

id|name
01|harry johns
02|adam taylor
03|john smith
04|john smith
05|bill manning
06|john smith

i need arrangement this:

harry johns
adam taylor
john smith (2)
bill manning
john smith

@matt: contemptible i problem formatting information controlling an embedded html list worked preview nonetheless final display.