MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE transactions (
  `user_id` INTEGER,
  `order_id` INTEGER,
  `create_time` VARCHAR(20),
  `payment_amount` INTEGER,
  `product` VARCHAR(12)
);

INSERT INTO transactions
  (`user_id`, `order_id`, `create_time`, `payment_amount`, `product`)
VALUES
  ('101', '10001', '4/2/2018 5:26', '48000', 'chair'),
  ('102', '10002', '4/2/2018 7:44', '25000', 'sofa'),
  ('101', '10003', '4/2/2018 8:34', '320000', 'ac'),
  ('101', '10004', '4/2/2018 8:37', '180000', 'water'),
  ('103', '10005', '4/2/2018 9:32', '21000', 'chair'),
  ('102', '10006', '4/2/2018 9:33', '200000', 'game console'),
  ('103', '10007', '4/2/2018 9:36', '11000', 'chair'),
  ('107', '10008', '4/2/2018 11:05', '10000', 'sofa'),
  ('105', '10009', '4/2/2018 11:06', '49000', 'ac'),
  ('101', '10010', '4/2/2018 12:05', '1200000', 'cc'),
  ('105', '10011', '4/2/2018 12:12', '98000', 'ac'),
  ('103', '10012', '4/2/2018 13:11', '85000', 'insurance'),
  ('106', '10013', '4/2/2018 13:11', '240000', 'cable tv'),
  ('108', '10014', '4/2/2018 13:15', '800000', 'financing'),
  ('106', '10015', '4/2/2018 13:18', '210000', 'phone');

Records: 15  Duplicates: 0  Warnings: 0


SELECT t1.user_id, t1.create_time AS order1_time, t2.create_time AS order2_time
FROM transactions t1
JOIN transactions t2 ON t2.user_id = t1.user_id
                    AND t2.order_id != t1.order_id
                    AND STR_TO_DATE(t2.create_time, '%m/%d/%Y %k:%i') BETWEEN
                           STR_TO_DATE(t1.create_time, '%m/%d/%Y %k:%i') 
                       AND STR_TO_DATE(t1.create_time, '%m/%d/%Y %k:%i') + INTERVAL 10 MINUTE


user_id
order1_time
order2_time


101
4/2/2018 8:34
4/2/2018 8:37

103
4/2/2018 9:32
4/2/2018 9:36

106
4/2/2018 13:11
4/2/2018 13:18

user_id	order1_time	order2_time
101	4/2/2018 8:34	4/2/2018 8:37
103	4/2/2018 9:32	4/2/2018 9:36
106	4/2/2018 13:11	4/2/2018 13:18