[dee]

SELECT *,COUNT(*) AS `count` FROM `tablea1` AS `t1`,`tablea2` AS `t2` WHERE t1.uid='1' AND t1.uid=t2.uid GROUP BY t2.name ORDER BY t1.id DESC;

jesi probao nesto ovako?

SELECT *,  COUNT(tabela2.uid) AS count FROM tabela2 LEFT JOIN tabela1 ON
				(tabela1.uid=tabela2.uid)  
				GROUP BY tabela1.uid ORDER BY tabela1.id DESC

lupam na brzinu iz jednog primjera sta sam ja koristio za slicnu stvar...