Speeding up MySQL NOT IN (Subquery)
SELECT * FROM table1 t1
  
  LEFT JOIN table2 t2 ON t1.field1 = t2.index_field
  
  WHERE

   t2.user_id = '2'



this will be optimized and will serve the purpose! although u can use EXIST as well!