According to Scripture, what happens when a man knows a woman, and what part does the LORD (YHVH) God play in it all?
Adam
(Genesis 4:1 ESV) Now Adam knew Eve his wife, and she conceived and bore Cain, saying, “I have gotten a man with the help of the LORD.”
(Genesis 4:25 ESV) And Adam knew his wife again, and she bore a son and called his name Seth, for she said, “God has appointed for me another offspring instead of Abel, for Cain killed him.”
Cain
(Genesis 4:17 ESV) Cain knew his wife, and she conceived and bore Enoch. When he built a city, he called the name of the city after the name of his son, Enoch.
Abraham
(Genesis 16:4 ESV) And he went in to Hagar, and she conceived. And when she saw that she had conceived, she looked with contempt on her mistress.
(Genesis 21:1-3 ESV) The LORD visited Sarah as he had said, and the LORD did to Sarah as he had promised. And Sarah conceived and bore Abraham a son in his old age at the time of which God had spoken to him. Abraham called the name of his son who was born to him, whom Sarah bore him, Isaac.
Isaac
(Genesis 25:20-21 ESV) and Isaac was forty years old when he took Rebekah, the daughter of Bethuel the Aramean of Paddan-aram, the sister of Laban the Aramean, to be his wife. And Isaac prayed to the LORD for his wife, because she was barren. And the LORD granted his prayer, and Rebekah his wife conceived.
Jacob
(Genesis 29:22-31 ESV) So Laban gathered together all the people of the place and made a feast. But in the evening he took his daughter Leah and brought her to Jacob, and he went in to her. (Laban gave his female servant Zilpah to his daughter Leah to be her servant.) And in the morning, behold, it was Leah! And Jacob said to Laban, “What is this you have done to me? Did I not serve with you for Rachel? Why then have you deceived me?” Laban said, “It is not so done in our country, to give the younger before the firstborn. Complete the week of this one, and we will give you the other also in return for serving me another seven years.” Jacob did so, and completed her week. Then Laban gave him his daughter Rachel to be his wife. (Laban gave his female servant Bilhah to his daughter Rachel to be her servant.) So Jacob went in to Rachel also, and he loved Rachel more than Leah, and served Laban for another seven years. When the LORD saw that Leah was hated, he opened her womb, but Rachel was barren.
(Genesis 29:32-35 ESV) And Leah conceived and bore a son, and she called his name Reuben, for she said, “Because the LORD has looked upon my affliction; for now my husband will love me.” She conceived again and bore a son, and said, “Because the LORD has heard that I am hated, he has given me this son also.” And she called his name Simeon. Again she conceived and bore a son, and said, “Now this time my husband will be attached to me, because I have borne him three sons.” Therefore his name was called Levi. And she conceived again and bore a son, and said, “This time I will praise the LORD.” Therefore she called his name Judah. Then she ceased bearing.
(Genesis 30:1-5 ESV) When Rachel saw that she bore Jacob no children, she envied her sister. She said to Jacob, “Give me children, or I shall die!” Jacob’s anger was kindled against Rachel, and he said, “Am I in the place of God, who has withheld from you the fruit of the womb?” Then she said, “Here is my servant Bilhah; go in to her, so that she may give birth on my behalf, that even I may have children through her.” So she gave him her servant Bilhah as a wife, and Jacob went in to her. And Bilhah conceived and bore Jacob a son.
(Genesis 30:7 ESV) Rachel’s servant Bilhah conceived again and bore Jacob a second son.
(Genesis 30:9-10 ESV) When Leah saw that she had ceased bearing children, she took her servant Zilpah and gave her to Jacob as a wife. Then Leah’s servant Zilpah bore Jacob a son.
(Genesis 30:12 ESV) Leah’s servant Zilpah bore Jacob a second son.
(Genesis 30:16-17 ESV) When Jacob came from the field in the evening, Leah went out to meet him and said, “You must come in to me, for I have hired you with my son’s mandrakes.” So he lay with her that night. And God listened to Leah, and she conceived and bore Jacob a fifth son.
(Genesis 30:19 ESV) And Leah conceived again, and she bore Jacob a sixth son.
(Genesis 30:22-23 ESV) Then God remembered Rachel, and God listened to her and opened her womb. She conceived and bore a son and said, “God has taken away my reproach.”
Judah
(Genesis 38:2-5 ESV) There Judah saw the daughter of a certain Canaanite whose name was Shua. He took her and went in to her, and she conceived and bore a son, and he called his name Er. She conceived again and bore a son, and she called his name Onan. Yet again she bore a son, and she called his name Shelah. Judah was in Chezib when she bore him.
(Genesis 38:18 ESV) He said, “What pledge shall I give you?” She replied, “Your signet and your cord and your staff that is in your hand.” So he gave them to her and went in to her, and she conceived by him.
Father of Moses
(Exodus 2:1-2 ESV) Now a man from the house of Levi went and took as his wife a Levite woman. The woman conceived and bore a son, and when she saw that he was a fine child, she hid him three months.
Elkanah
(1 Samuel 1:1-5 ESV) There was a certain man of Ramathaim-zophim of the hill country of Ephraim whose name was Elkanah the son of Jeroham, son of Elihu, son of Tohu, son of Zuph, an Ephrathite. He had two wives. The name of the one was Hannah, and the name of the other, Peninnah. And Peninnah had children, but Hannah had no children. Now this man used to go up year by year from his city to worship and to sacrifice to the LORD of hosts at Shiloh, where the two sons of Eli, Hophni and Phinehas, were priests of the LORD. On the day when Elkanah sacrificed, he would give portions to Peninnah his wife and to all her sons and daughters. But to Hannah he gave a double portion, because he loved her, though the LORD had closed her womb.
(1 Samuel 1:19-20 ESV) They rose early in the morning and worshiped before the LORD; then they went back to their house at Ramah. And Elkanah knew Hannah his wife, and the LORD remembered her. And in due time Hannah conceived and bore a son, and she called his name Samuel, for she said, “I have asked for him from the LORD.”
(1 Samuel 2:21 ESV) Indeed the LORD visited Hannah, and she conceived and bore three sons and two daughters. And the boy Samuel grew in the presence of the LORD.
David
(2 Samuel 11:4-5 ESV) So David sent messengers and took her, and she came to him, and he lay with her. (Now she had been purifying herself from her uncleanness.) Then she returned to her house. And the woman conceived, and she sent and told David, “I am pregnant.”
Husband to the Wealthy Shunammite Woman
(2 Kings 4:17 ESV) But the woman conceived, and she bore a son about that time the following spring, as Elisha had said to her.
Isaiah
(Isaiah 8:3 ESV) And I went to the prophetess, and she conceived and bore a son. Then the LORD said to me, “Call his name Maher-shalal-hash-baz;
Hosea
(Hosea 1:3 ESV) So he went and took Gomer, the daughter of Diblaim, and she conceived and bore him a son.
(Hosea 1:6 ESV) She conceived again and bore a daughter. And the LORD said to him, “Call her name No Mercy, for I will no more have mercy on the house of Israel, to forgive them at all.
(Hosea 1:8 ESV) When she had weaned No Mercy, she conceived and bore a son.
This seems to clearly establish that when a man knows a woman, she conceives and brings forth children with the help of the LORD (YHVH) God.