My-InstantCMS.Ru

public function getMyComments($user_id) {
	$this->selectOnly('i.*'); //все поля комментарии
	$this->joinUserLeft(); //пользователь
	$this->join('con_posts', 'p', "p.id = i.target_id AND p.user_id = '{$user_id}'"); //связь
	$this->filterEqual('p.user_id', $user_id); //условие
	$this->filterNotEqual('i.user_id', $user_id); //убрать комментарии самого автора
	return $this->get('comments', function($item, $model){
            $item['user'] = array(
                'id' => $item['user_id'],
                'nickname' => $item['user_nickname'],
                'avatar' => $item['user_avatar']
            );
       return $item;
        });
}

SELECT i.*, u.nickname as user_nickname, u.avatar as user_avatar
FROM cms_comments i
LEFT JOIN cms_users as u ON u.id = i.user_id
JOIN cms_con_posts as p ON p.id = i.target_id AND p.user_id = '2'
WHERE (p.user_id = '2') AND (i.user_id <> '2')