You can take help of CTE to do this.
I don't have much knowledge on MySQL but if you can translate T-SQL (SQL Server) to MySQL query then you can refer following T-SQL query -
DECLARE @tbl AS TABLE(n INT)
;WITH cte_demo(n) AS
(
SELECT 1 AS n
UNION ALL
SELECT n + 1
FROM cte_demo
WHERE n < 1000
)
INSERT INTO @tbl SELECT * FROM cte_demo OPTION (MAXRECURSION 1000)
SELECT ISNULL(id,0) AS Id, ISNULL(amount,0) AS amount,ISNULL([time diff],n)
FROM
(
SELECT 1 id, 200 amount, 6 [time diff]
UNION ALL
SELECT 2 , 234 , 8
UNION ALL
SELECT 3 , 234 , 9
UNION ALL
SELECT 4 , 349 , 10
) t1
RIGHT JOIN @tbl t2 ON t2.n=t1.[time diff]
Hope, it helps :)
if you need further help please, let me know.