Как правильно получить данные с MySql?

$rowU = $db->super_query( "SELECT * FROM `users` WHERE id = '" . $row['id'] . "'" );
$tpl->set( '{fix}', $rowU['balance'] );

CREATE TABLE IF NOT EXISTS `PREFIX_user_balance` (
  `bid` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `balance` int(11) NOT NULL,
  PRIMARY KEY (`bid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2;

$tpl->set( '{realmoney}', stripslashes( $row['realmoney'] ) );

 $sql_balanse = $db->super_query("SELECT b.*, u.* FROM " . PREFIX . "_user_balance b LEFT JOIN " . PREFIX . "_users u ON (b.uid=u.user_id) WHERE u.user_id = '{$row['user_id']}'");

    if($sql_balanse) {
        $tpl->set( '{realmoney}', stripslashes( $sql_balanse['balance'] ) );
    }   else {
        $tpl->set( '{realmoney}', "0" );
    }

Вывод не из users 

$tpl->set( '{realmoney}', "0" );

    $rowU = $db->super_query( "SELECT * FROM `money` WHERE `username` = '{$row['username']}'" );

    $tpl->set( '{balance}', stripslashes( $rowU['balance'] ) );

WHERE `username` = '{$row['username']}'" );