How to write an INSERT-SELECT query?

Question

MySQL

In general, it is necessary to add a new value to the old balance indicator.
Query where is current balance running:

INSERT INTO `test_db_vytrat` (`balans`) select balans+1000 from test_db_vytrat where user_id = 1 ORDER BY `id` DESC LIMIT 0 , 1;

But in addition to the balance, I need to write down other values, and here is the problem.
But on request:

INSERT INTO `test_db_vytrat` (`id`, `user_id`, `data`, `cat`, `oper`, `suma_oper`, `balans`, `note`) VALUES (NULL, '$_POST[uid]', '$_POST[data]', '$_POST[category]', '$_POST[type]', '$_POST[suma]', select balans+1000 from test_db_vytrat where user_id = 1 ORDER BY `id` DESC LIMIT 0 , 1, '$_POST[note]');

SQL swears.

Answer 1

INSERT INTO `test_db_vytrat` (`id`, `user_id`, `data`, `cat`, `oper`, `suma_oper`, `balans`, `note`) 
SELECT NULL as id, '{$_POST[uid]}' as user_id, '{$_POST[data]}' as data, ..., balans+1000 as balans, '{$_POST[note]}' as note from test_db_vytrat where user_id = 1 ORDER BY `id` DESC LIMIT 0 , 1;