SELECT id FROM users WHERE name = 'jon doe' LIMIT 1

// result: 1

SELECT * FROM comments WHERE user_id = 1

SELECT comments.* FROM comments
JOIN users ON users.id= t1.user_id
WHERE users.name = 'jon doe'