转换我的查询以获取两个表的列

I have mysqli query that do my job correctly when counting number of rows only, now with the same query i want get appropriated column values.

Here my query:

$query = $mysqli->query("
SELECT *
  FROM verify 
 WHERE user_id = '$uid' 
    AND verified = 1
   AND id NOT IN (SELECT verified_id FROM verified WHERE user_id='$uid' AND banned = '0' GROUP BY verified_id)
");
$infos = $query->fetch_assoc();
$counting = $query->num_rows;

How to get infos inside VERIFIED table ? VERIFY table's infos got successfully.

EDIT

I want get for example column value of the VERIFIED table like: $infos["email"];

For now i can get only column values of VERIFY table.