SELECT * FROM `user` INNER JOIN `permission` USING(`id`);

SELECT * FROM `user` INNER JOIN `permission` USING(`id`);

<?

mysql_connect('localhost', 'root', '');

mysql_select_db('a_test');

$q     = mysql_query("SELECT * FROM `users` LEFT JOIN `permissions` ON `users`.`id` = `permissions`.`uid` WHERE `id`=1;");

$row   = mysql_fetch_row($q);

$count = count($row);

$user = array();

for ($i = 0; $i < $count; $i++) {

    $key        = mysql_field_name($q, $i);

    $user[$key] = $row[$i];

}

$userobj = new stdClass;

for ($ix = 0; $ix < $count; $ix++) {

    $key           = mysql_field_name($q, $ix);

    $userobj->$key = $row[$ix];

}

print_r($user);

print_r($userobj);

echo $user['name'];

echo PHP_EOL;

echo $userobj->name;