update Category 
set topic_num=ct from Category,(
select count(tid) as ct,category_id as cid 
from Topic 
where userid=$userid$ 
group by category_id) as c 
where category_id=cid and userid=$userid$