Does this work?
SELECT l.me_id AS me,
l.you_id AS you,
a.l AS left,
a.aspect,
a.r AS right,
l.id AS link_id,
c.comment,
concat(m.first_name, ' ', m.surname) AS me_name,
concat(y.first_name, ' ', y.surname) AS you_name
FROM aspects a,
links_aspects la,
links l,
syn_comments c
JOIN users m ON
l.me =
m.id JOIN users y on l.you =
y.idWHERE (a.r = 'Venus' AND a.l = 'Venus')
AND a.type = 'synastry'
AND la.aspect_id =
a.id AND
la.id = c.links_aspects_id
AND la.link_id =
l.id;