MySQL 5.7

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

CREATE TABLE `users` (
  `id` bigint NOT NULL,
  `login` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `users`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT;

Records: 0  Duplicates: 0  Warnings: 0



Records: 0  Duplicates: 0  Warnings: 0


INSERT INTO `users` VALUES (1,'test1'),
(2,'test2'),
(3,'test3'),
(4,'test4')

Records: 4  Duplicates: 0  Warnings: 0


CREATE TABLE `stat_times` (
  `uid` bigint NOT NULL,
  `type` bigint NOT NULL,
  `time` bigint NOT NULL
);
INSERT INTO `stat_times` VALUES (1,1,55),
(1,2,113),
(3,1,86),
(3,2,423)

Records: 4  Duplicates: 0  Warnings: 0


SELECT `users`.`login`, `stat_times`.`time` FROM `users`
  LEFT JOIN `stat_times` ON `stat_times`.`uid` = `users`.`id`
WHERE `stat_times`.`uid` IS NOT NULL


login
time


test1
55

test1
113

test3
86

test3
423