How to delete record from two tables using mysql

See more:

CodeIgniter

I have two tables USER_INFO and USERS. It contains userid and id respectively. I want to delete complete record when userid and id get match.
suppose in USER_INFO table userid =125, and in USERS table id=125;
what query should i use to delete complete row.

What I have tried:

$tables = array('USER_INFO ', 'USERS');
$this->db->where('id''userid', '125');
$this->db->delete($tables);



or

DELETE USER_INFO, USERS FROM USER_INFO INNER JOIN USERS WHERE USER_INFO.userid = USERS.id =125