SELECT a.*, u.user_name, u.user_email, u.user_site FROM article AS a LEFT JOIN users AS u ON a.user_id = u.user_id WHERE a.article_id = '{$art_id}'
$article = new Article(); $article->where('id', $art_id); $article->include_related('user', array('username', 'email', 'site')); $article->get();