Please check this code:

select

a.*,

STUFF((SELECT ', '+name FROM bb WHERE colorid = a.colorid FOR XML PATH('')) , 1 , 1 , '' )

from aa a