How to make a record in 2 mysql tables?

Question

MySQL

Hello, please tell me how to do it right
, I have 2 codes,
this one gets the user's email from the table

static function getEmail($id='') {

    global $db;
    if(!$id) return;
    $email=$db->fetchRow('select email from '.TABLE_USERS.' where id="'.$id.'"');
    return $email;
  }

and this one adds an entry to the database when someone clicks on banners

function addHit($id=0) {

    global $db;
    if(!$id) $id=$this->id;
    $res_del=$db->query('update '.TABLE_BANNERS.' set `clicks` = `clicks`+1 where `id`="'.$id.'"');
    return 1;
  }

how do I substitute email from the first $ email when executing the second script and put it in the third table, for example
, class_click in the email line, and each time function addHit is executed, a new entry will be added to the database in the class_click table

Answer 1

well, for example, that the mysql server is not running

Answer 2

I don't understand what the problem is to call the getEmail method in the addHit function and store the email in a variable and do whatever.
What does 2 codes mean?
Made very unclear.
And don't use global $db; globals are always bad.