SELECT
cvr.`c_id` AS "c_id",
usr.`id` AS "id",
usr.`name` AS "name",
usr.`lastname` AS "lastname",
usr.`lastact` AS "lastact"
FROM
`conversation_mem` cvr_m
LEFT JOIN `conversation` cvr ON cvr.`c_id` = cvr_m.`c_id`
LEFT JOIN `user_profile` usr ON usr.`id` = cvr_m.`user`
WHERE
cvr_m.`user` = '$my_id'
GROUP BY
cvr.`c_id`