ad occhio...

select distinct tag.* from tag inner join tagcloud on tag.id=tagcloud.id_tag where tagcloud.id_articolo in
(select distinct tagcloud.id_articolo from tagcloud inner join tag on tag.id=tagcloud.id_tag where tag.nome='$tag')