SQL subquery in INSERT?

SQL subquery in INSERT?

Is it possible to use a subquery in an INSERT statement?
INSERT INTO table (age, p_id)
VALUES('22', '(SELECT id FROM people WHERE name='Bob')')
Is there a working form of what I'm attempting?