CREATE TABLE `tb_project` (
  id int NOT NULL PRIMARY KEY AUTO_INCREMENT,
  project_name varchar(225) NOT NULL,
  date date,
  biaya text
)

INSERT INTO `tb_project` (`id`, `project_name`, `date`, `biaya`) VALUES
(NULL, 'Project 1', '2022-11-01', 'biaya 10.000'),
(NULL, 'Project 2', '2022-11-01', 'biaya 10.000');

CREATE TABLE `tb_project_category` (
  id int NOT NULL PRIMARY KEY AUTO_INCREMENT,
  project_id int NOT NULL,
  category_name varchar(225) NOT NULL
)

INSERT INTO `tb_project_category` (`id`, `project_id`, `category_name`) VALUES
(NULL, 2, 'Iklan'),
(NULL, 3, 'iOS'),
(NULL, 3, 'Redesign')

SELECT * FROM `tb_project` as `tbj` JOIN `tb_project_category` as `tbc`
ON `tbj`.`id` = `tbc`.`project_id`;